Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Excel to prepare the following budgets for December 2021: 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor
Use Excel to prepare the following budgets for December 2021: 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor cost budget 5. Factory overhead cost budget 6. Costs of goods sold budget. Work in process at the beginning of December is estimated to be $29,000, and work in process at the ending of December is desired to be $35,400. Create only one excel workbook and use a different tab within the workbook for each budget - 6 tabs. Formatting should include appropriate headings. See example budgets in the text for format. Each student will upload his/her Budget Project excel workbook onto Canvas by the due date. Information for Budgeted Income Statement and Supporting Budgets: The budget director of Birdzerk Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December: A. Estimated sales for December: Bird house. Bird feeder.... B. Estimated inventories at December 1: 3,200 units at $50 per unit 3,000 units at $70 per unit Direct materials: Wood Plastic.... 200 ft. 240 lbs. Finished products: Bird house.. Bird feeder... 320 units at $27 per unit 270 units at $40 per unit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started