Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

where did I go wrong on the excel sheet Schedule 1: Sales Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Unit Sales 6000

where did I go wrong on the excel sheet

image text in transcribed
Schedule 1: Sales Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Unit Sales 6000 8000 8000 9000 31000 Unit Selling Price $650 $650 $650 $650 $650 Total sales $3,900,000 $5,200,000 $5,200,000 $5,850,000 $20,150,00 Schedule 2: Production Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Units Prodcued 6300 7200 9500 9000 32000 Add: Desired Ending Finished Goods 1300 1500 200 1000 Total Production Required 7600 8700 11500 10000 37800 Less: Beginning Finished Goods 1300 1500 2000 Total Units Needed To Be Prodcued 7600 7400 10000 8000 33000 Schedule 3: Direct Materials Purchases Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Direct Materials Required 24000 32000 32000 36000 124000 Add: Desired Ending Inventory 1314 2040 240 1800 Total Needs 25314 34040 34400 37800 131554 Less: Beginning Inventory 6570 6570 Direct Materials To Be Purchased 18744 34040 34400 37800 124984 Schedule 4: Direct Labor Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Units To Be Produced 7600 7400 1000 8000 33000 Direct Labor Hours per Unit 5 5 5 Total Direct Labor Hours 38000 37000 50000 40000 165000 Direct Labor Costs per Hour $10 $10 $10 $10 $10 Total Direct Labor Cost $380,000 $370,000 $500,000 $400,000 $1,650,000 Schedule 5: Overhead Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Variable Overhead per Direct Labor Hour $6 $6 $6 $6 $6 Direct Labor Hours 38000 37000 50000 40000 165000 Total Variable Overhead Cost $228,000 $222,000 $300,000 $240,000 $990,000 Fixed Overhead Cost $700,000 $700,000 $700,000 $700,000 Schedule 6: Selling & Administration Expense Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 Year Sales (in units) 10000 1500 20000 15000 60000 Variable selling & Admin Rate $0.75 $0.75 $0.75 $0.75 $0.75 Total Variable S & A Expense $7,500 $11,250 $15,000 $11,250 $45,000 Total Fixed S & A Expense 150000 150000 150000 150000 600000 Total Selling & Admin Expense $157,500 $161,250 $165,000 $161,250 $645,000

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

Financial Accounting Theory And Analysis Text And Cases

Authors: Richard G Schroeder, Myrtle W Clark, Jack M Cathey

13th Edition

1119577772, 9781119577775

More Books

Students also viewed these Accounting questions