mba642problem3

mba642problem3 - Problem 3 worth 10 pts. Save your file...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 3 worth 10 pts. Save your file using your first initial, last name, and name of problem (e.g., jstevens_problem3.xls) Due by Tuesday, July 19th 11:59 pm Central time. Upload to step 2 of this assignment. I will not accept any late problems, since I will post my solution on Wed. July 20th at 8 am central time so you can review my solution before the exam. This problem 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 budget requirements that are stated on the solution worksheet tab. 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. 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 May 2011. Estimated sales for May Bird House 35,000 units at $42 per unit Bird Feeder 26,000 units at $70 per unit Direct materials Estimated inventories at May 1(beginning) Wood 2600 feet Plastic 3200 pounds Estimated inventories at May 31st(ending) Wood 3500 feet Plastic 2800 pounds Direct materials used in production: In the manufacture of a Bird House: Wood 0.80 feet per unit of product Plastic 0.50 pounds per unit of product In the manufacture of a Bird Feeder: Wood 1.20 feet per unit of product Plastic 0.85 pounds per unit of product Estimated cost of direct materials Wood $6.40 per feet Plastic $0.90 per pound Work in process-given in total of the 2 products Estimated inventories at May 1(beginning) $27,000 Estimated inventories at May 31st(ending) $32,400 Finished Goods Estimated inventories at May 1(beginning) Bird House 4900 units at $25 per unit Bird Feeder 2,500 units at $35 per unit Estimated inventories at May 31st(ending) Bird House 5300 units at $24 per unit Bird Feeder 2,100 units at $36 per unit Direct Labor Requirements: Bird House Fabrication Department 0.25 hour at $13 per hour Assembly Department 0.3 hour at $10 per hour Bird Feeder Fabrication Department 0.45 hour at $13 per hour Assembly Department 0.35 hour
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

mba642problem3 - Problem 3 worth 10 pts. Save your file...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online