Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Payroll Accounting 2016

Authors: Bernard J. Bieg, Judith Toland

26th edition

978-1305665910, 1305665910, 1337072648, 978-1337072649

More Books

Students also viewed these Accounting questions

Question

What is variable costing? List its advantages and disadvantages.

Answered: 1 week ago