Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help me fill out the blanks in the first photo? The other photos should help solve the first photo. D MASTER BUDGET PROJECT:
Can someone help me fill out the blanks in the first photo? The other photos should help solve the first photo.
D MASTER BUDGET PROJECT: BUDGETED INCOME STATEMENT BY QUARTER ACCT 5362 Accounting Principles 1 + Using the previous budgets developed, prepare a Budgeted Income Statement by Quarter for 2021 using the following template: 5 7 Husky Co. Budgeted Income Statement by Quarter For the Year Ended Dec 31, 2021 01 02 03 04 Annual Sales 2 Cost of Goods Sold 15 GEOSS Proti SG&A Expenses 15 Operating Profit 1 Interest Expense Taxable income Income Tax Net Income 323,655 1 2 MASTER BUDGET PROJECT SALES, PRODUCTION, DIRECT MATERIALS, AND DIRECT LABOR BUDGETS INSTRUCTIONS ACCT 5362 Accounting Principles The budgeting process begins with a perpjection of sales Management provides the following estimates for 2021 and the fint bao quarters at 2022 4 5 Projected Sales in Uits at $60 Selling Price 7 Q1 02 03 00 2021 7,000 8.000 12,000 16,000 2022 7.000 1.000 12000 16.000 Prepare Budapets for Sales Production Direct Materials and Direct Labor for 2021, using the following information and templates 1 15 Annual 1 Sales Budget Units Price Sales 01 7,000 560 $420,00 02 03 04 8.000 12.000 16.000 SGO $60 $180.000 $720.000 960.000 3000 560 52 580.000 26 29 Production Budget Sales 30 Annual 21 32 Ending lov Req Units Beg Inv Req Production QL 7,000 1,600 8,600 70,00 1,600 Q2 8,000 2.400 10,400 1600 8,800 Q3 12.000 3.200 15.200 2400 12,800 04 16,000 1,400 17,400 3200 14.200 39 13,000 1.400 44.000 7000 37,400 34 35 36 Direct Materials Inputs: Each unit requires 23 pounds costing $1.45 per pound 40 Annual 37400 23 DM Budget Units to produce DM per unit Total pounds DM End Iny -Beg iny DM Required Cost per pound Total Cost of DM Q1 1,600 223 3,680 0 0 3,680 $1.45 S5,336 02 3,800 23 20,240 0 0 20,240 S1:45 $29.348 03 04 12 00 14,200 2.3 23 29.440 32,660 0 0 0 0 29.4.00 32.660 $1.45 $1.45 $42,688 $17,397 2.3 85,020 0 0 36,020 SLAS 512720 49 9 to 11 Overhead Budget Inputs: Variable overhead: $0.40 per DLH Fixed overhead: $270,000 per quarter FOH applied on the basis of budgeted DLH 13 AN OH Budget VOH FOH Total 01 $2.310 $270.00 $272.310 15 Q2 Q3 04 52,640 $3.950 5520 $270,000 $270,000 $270,000 5272.600 $273.960 $275,280 514190 S1080.000 51.094199 17 10 Annual 2 Selling General & Administrative Budget Inputs: 2 Variable SG&A= $2.00 per unit+1% Sales Fixed SG&A - 590,000 per quarter 2 SG&A Budget VSGA FSGA Total SGA Q1 $18,200 590.000 S10.200 02 520.00 $90,000 S110 800 Q3 04 531,200 541.600 $90,000 $90,000 $121,200 STOC SH1,000 S000 SIMO 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