Management Accounting( Have already put the information in Excel)

Sales Budget (for the yea r] Forecaste cl Unites %from selling for the January prices year to August per unit Table 200 0.05 5 1,200 Chair 1200 0.05 $ 150 Desk 180 0.08 S 900 %from Septemb er to selling Decembe prices r per unit 0.15 5 1,272 0.15 $ 159 0.08 S 900 The current costs of production per unit are as follows: Direct Direct Materials Labour 5 360 s 420 s 40 s 50 s 340 s 300 Direct material costs for desks are expected to increase by 5% at the beginning of May. The unit production schedule for the year is as follows Other expenditures and costs are expected to be as follows: Estimated capital expenditures to be purchased in February are as follows: Tables and Chairs: Rent $ 34,000 Month New com $ 3,500 Feb 7.5% of total estimated sales in each month during January through June Utilities $ 250 Month Lathe $ 18,000 Feb 10% of total estimated sales in each month during July through November Clerk's ani $ 1,500 Month Other mis $ 12,000 Feb 5% of total estimated sales during December Telephone $ 90 Month Desks: Insurance $ 250 Month Sale of Exi $ 550 March Business t $ 200 Month-January through June Total estimated sales are to be produced evenly over the year in every second month, starting in January $ 210 Month-Jul-Dec Income ta 21% Quarterly Income taxes are estimated to be 21% of taxable income and are paid quarterly at the end of March, Office sup $ 450 April June, September, and December S 450 Nov CCA 6,250 Month Annual sa $ 4,500 MonthAt the beginning of the year, the cash balance is expected to be $3,000 Table Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Sales Units 10 10 10 10 10 10 10 10 30 30 30 30 200 Price per uni $ 1,200 $ 1,200 $ 1,200 $ 1,200 $ 1,200 $ 1,200 $ 1,200 $ 1,200 $ 1,272 $ 1,272 $ 1,272 $ 1,272 Total Sales $12,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 38,160 $ 38,160 $ 38,160 $ 38,160 $ 248,640 Production ( 15 15 15 15 15 15 20 20 20 20 20 9 199 Dircet Mater $ (5,400) $ (5,400) $ (5,400) $ (5,400) $ (5,400) $ (5,400) $ (7,200) $ (7,200) $ (7,200) $ (7,200) $ (7,200) $ (3,240) $ (71,640) Diect Labour $ (6,300) $ (6,300) $ (6,300) $ (6,300) $ (6,300) $ (6,300) $ (8,400) $ (8,400) $ (8,400) $ (8,400) $ (8,400) $ (3,780) $ (83,580) Chair Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Units 60 60 60 60 60 60 60 60 180 180 180 180 1200 Price per uni $ 150 $ 150 $ 150 $ 150 $ 150 $ 150 $ 150 $ 150 S 159 S 159 S 159 $ 159 Total Sales $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 28,620 $ 28,620 $ 28,620 $ 28,620 $ 186,480 Production l 90 90 90 90 90 90 120 120 120 120 120 60 1200 Dircet Mater $ (3,600) $ (3,600) $ (3,600) $ (3,600) $ (3,600) $ (3,600) $ (4,800) $ (4,800) $ (4,800) $ (4,800) $ (4,800) $ (2,400) $ (48,000) Diect Labour $ (4,500) $ (4,500) $ (4,500) $ (4,500) $ (4,500) $ (4,500) $ (6,000) $ (6,000) $ (6,000) $ (6,000) $ (6,000) $ (3,000) $ (60,000) Desk Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Units 15 15 15 15 15 15 15 15 15 15 15 15 180 Price per uni $ 900 $ 900 $ 900 $ 900 $ 900 $ 900 $ 900 900 $ 900 $ 900 $ 900 $ 900 Total Sales $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 13,500 $ 162,000 Production l 0 30 30 30 30 30 30 180 Dircet Mater $ $ (1,200) $ $ (1,200) $ $ (1,200) $ $ (1,200) $ $ (1,200) $ $ (1,200) $ (7,200) Diect Labour $ $ (1,500) $ $ (1,500) $ $ (1,500) $ $ (1,500) $ $ (1,500) $ $ (1,500) $ (9,000)