Management Accounting( Have already put the information in Excel)

Total estimated sales are to be produced evenly over the year in every second month, starting in January

Other expenditures and costs are expected to be as follows:

Rent $3,400 per month

Utilities $250 per month

Clerk's annual salary including employer share of CPP and EI: $18,000

Telephone and Internet access $90 per month

Insurance for the year of $3,000, paid monthly in equal installments

Business taxes of $200 per month are expected to be paid monthly from January through June. Taxes are expected to increase by 5% effective July 1.

Office supplies of $450 were purchased during April and another $450 during November

Annual salary of $54,000 for the shareholder/manager (not included in labor costs above)

Estimated capital expenditures to be purchased in February are as follows:

New computer $3,500 Lathe 18,000 Other miscellaneous tools 12,000

The existing computer is expected to be sold in March at a selling price of $550.

Income taxes are estimated to be 21% of taxable income and are paid quarterly at the end of March, June, September, and December. The company expects a Capital Cost Allowance (CCA) of $7,500 for the year.

At the beginning of the year, the cash balance is expected to be $3,000, and the company is forecasted to have no accounts receivable, inventory, accounts payable, or salaries/wages payable.

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)