Please make sure you read the academic honesty policy, since I


Question Description:

35

Request assistance on answering the questions on the attached spreadsheet. Project 4.xlsx Please make sure you read the academic honesty policy, since I want to make sure everyone realizes that they should not be discussing this exam outside the discussion board. This is an individual assignment and should be completed by each student on their own. I realize some of you maybe best friends or relatives, but this is an individual assignment and you should not be working as a team. Academic Honesty Policy: Each student is assumed to be a mature and responsible adult with high academic and moral standards. There is no place in the business profession or the classroom for dishonesty. Therefore, any student found cheating or presentin g material in a dishonest fashion would be dismissed from the course and given a course grade of “F.” You should not exchange files or discuss turn in problems or take home exams outside the discussion board . It is unfair to your classmates to discuss turn-in problems and take home exams via e -mail or to send files with the solution to any member of the class. I always have a discussion thread set up for students to ask questions, so this is the place you should ask questions on these assignments and ex ams. Remember, it does not matter what type of assignment it is, if you are found cheating you will receive an F for the course and the College of Business will be informed of your actions for further proceedings. Project 4 is due by Tuesday, October 22nd. Send via the assignment area and make sure you save your file with first initial of first name and last name. You will be graded on the accuracy of your answer and usage of cell referencing in the DATA area. Covers material in chapter 9. This project covers material in chapter 9 and I have extensive budget demonstrations in the chapter 9 course documents folder. I have a template set up on the solution worksheet that you should use to complete the required budgets that are stated on the solution worksheet tab along with a what if question and article questions. You need to use cell references in the development of your budgets. You must use this worksheet to reference the data that is being inputted onto the budgets on the solution worksheet. Grading Rubric for Project 4 Possible points 1. Prepare a sales budget for November 2. Prepare a production budget for November. 0.5 1 3. Prepare a supporting schedule to determine required material for production and a direct materials purchase budget for November 4. Prepare a direct labor cost budget for November. 5. Prepare a factory overhead cost budget for November 6. Prepare a cost of goods sold budget for November. 0.5 2 2 2 7. Prepare a selling and administrative budget for November, set up based on categorization of expenses into selling and administrative costs. 8. Prepare a budgeted income statement for November. 1 2 9. What if the company decides to start a new advertising campaign 1 10. Article answers-.75 each 3 Total 15 If you type in any numbers in the solution, I will take off 5 pts., since we use Excel so that we can update budgets or do what if analysis without retyping numbers. The budget director for Bird House Unlimited, Inc., has gathered the following data for use in developing the budgeted income statement for November 20XX. Estimated sales for November Bird House 29,000 units at $33 per unit Bird Feeder 25,000 units at $37 per unit Direct materials Estimated inventories at November 1(beginning) Wood Plastic Estimated inventories at November 30th(ending) Wood Plastic 2600 feet 3200 pounds 3500 feet 2800 pounds Direct materials used in production: In the manufacture of a Bird House: Wood Plastic 0.80 feet per unit of product 0.50 pounds per unit of product In the manufacture of a Bird Feeder: Wood Plastic 1.20 feet per unit of product 0.75 pounds per unit of product Estimated cost of direct materials Wood Plastic Work in process-given in total of th

Answer

35