Memorandum: Boom Broom Manufacturers

Memorandum: Boom Broom Manufacturers

Boom Broom manufacturer is located in South Brisbane. It produces desk and sell the product to state school. Mr. Maison Broom, the owner of the company has hired you as a consultant to prepare a master budget and to provide an advice how to improve the company’s financial performance.

Memorandum

To:       Mr. Maison Broom

Date:     13-09-2019

From:    XXX

Subject: Recommendation to improve the financial performance of the company

As per request, I have conducted an in-depth analysis of the financial performance of your company. The resultant figures are quite troubling. The company is currently not earning more than 8% of the profit on monthly basis, while its Gross Profit margin is also lower than 25%. This shows that Boom Broom Manufacturing is manufacturing desks at a very high cost. The company is manufacturing the desks at the cost of $80 and more per unit while its selling price is $115 per unit. The main cost is the highest in the cost of direct labor and the Manufacturing overhead costs per unit. The company is incurring way too much cost on its labor and its overhead.

It is therefore recommended to lower the labor costs as a first step. Using the same labor in different shifts or working on increasing the efficiency of the labor so that fewer labor hours are needed for the manufacturing of the units is needed. Furthermore, the company can also work on increasing its sales volume to compensate for the high costs of production or overheads. However, it is for the long-term plan. Initially, it is recommended that your company work on getting lower prices from the labor and lower its overhead costs as well. The depreciation amount is one of the highest costs in the Selling and Admin Expense as well as in the Overhead. It is also suggested to look into the method that has been used for the calculation of this depreciation expense as it is very high.

Furthermore, the company is also incurring a high cost of salaries of the staff as well. This can be looked into as well. It is suggested that your company should work on increasing the efficiency of your employees and the workers and reduce the depreciation expense by changing the method used for the calculation of its expenses. Moreover, Boom Broom should also look into targeting more clients and improving its sales volume.

Regard

Appendix:

Boom Broom Manufacturing
Sales Budget
For the Quarter Ending March 31
Jan Feb Mar Total
Units                   20,000                  30,000                  35,000                  85,000
Selling Price  $                    115  $                    115  $                    115  $                    115
Sales  $        2,300,000  $        3,450,000  $        4,025,000  $        9,775,000

 

Boom Broom Manufacturing
Production Budget
For the Quarter Ending March 31
Jan Feb Mar Total
Sales                   20,000                  30,000                  35,000                  85,000
Add: Desired Ending Inventory                   18,000                  21,000                  25,200                  64,200
Total Inventory Needed                   38,000                  51,000                  60,200                149,200
Less: Beg Inventory                   19,000                  25,500                  30,100                  74,600
Unit to be Produced                   19,000                  25,500                  30,100                  74,600

 

Boom Broom Manufacturing
Direct Material Purchase Budget
For the Quarter Ending March 31
January February March Total
Wood Components Wood Components Wood Components Wood Components
Unit to be Produced                   19,000                  19,000                  25,500                  25,500            30,100               30,100      74,600               74,600
DM Per Unit 2 6 2 6 2 6 2 6
Production Need                   38,000                114,000                  51,000                153,000            60,200            180,600    149,200            447,600
Add: Desired End DM                   25,500                  76,500                  30,100                  90,300            36,000            108,000      91,600            274,800
Total Material Needed                   63,500                190,500                  81,100                243,300            96,200            288,600    240,800            722,400
Less: Beg DM                   40,550                121,650                  48,100                144,300            56,000            168,000    144,650            433,950
Total DM to be Purchased                   22,950                  68,850                  33,000                  99,000            40,200            120,600      96,150            288,450
Cost Per Unit 10 5 10 5 10 5 10 5
Total Cost of DM to be Purchased                229,500                344,250                330,000                495,000          402,000            603,000    961,500         1,442,250

 

Boom Broom Manufacturing
Direct Labor Budget
For the Quarter Ending March 31
Jan Feb Mar Total
Unit to be Produced                   19,000                  25,500                  30,100                  74,600
DL hours per unit 3 3 3 3
Total DL hours needed                   57,000                  76,500                  90,300                223,800
DL cost per hour  $                 14.25  $                14.25  $                14.25  $                14.25
Total DL Cost                812,250            1,090,125            1,286,775            3,189,150

 

Boom Broom Manufacturing
Overhead Budget
For the Quarter Ending March 31
Jan Feb Mar Total
Budgeted DL Hours Required                   57,000                  76,500                  90,300                223,800
Variable Man Overhead Rate  $                   2.40  $                   2.40  $                   2.40  $                   2.40
Budgeted Variable Overhead 136800 183600 216720 537120
Budgeted Fixed Overhead  $      338,000.00  $      338,000.00  $      338,000.00  $      338,000.00
Total Overhead  $      474,800.00  $      521,600.00  $      554,720.00  $      875,120.00

 

Boom Broom Manufacturing
Selling and Administrative Expenses Budget
For the Quarter Ending March 31
Jan Feb Mar Total
Budgeted DL Hours Required                   57,000                  76,500                  90,300                223,800
Variable S&A Expense Rate 3.6 3.6 3.6 3.6
Budgeted Variable S&A Expenses                205,200                275,400                325,080                805,680
Budgeted Fixed S&A Expense  $            110,000  $            110,000  $            110,000  $            110,000
Total S&A Expense  $            315,200  $            385,400  $            435,080  $            915,680

 

Boom Broom Manufacturing
Ending Finished Goods Inventory Budget
For the Quarter Ending March 31
Jan Feb Mar
DM Cost Per Unit 15 15 15
DL Cost  $                 42.75  $                42.75  $                42.75
MOH Cost                     42.69                     31.81                     26.95
Total Cost Per Unit  $              100.44  $                89.56  $                84.70
Ending Finished Goods Inventory Units                   18,000                  21,000                  25,200
Cost Per Unit  $              100.44  $                89.56  $                84.70
Ending Finished Goods Inventory  $        1,808,005  $        1,880,797  $        2,134,444

 

Boom Broom Manufacturing
Cost of Goods Sold Schedule
For the Quarter Ending March 31
Jan Feb Mar Total
Finished Goods Inventory, Jan 1 15000                  18,000                  21,000
WIP inventory, Jan 1 0 0 0
Direct Material Inventory Beg                162,200                192,400                224,000
Purchases                   91,800                132,000                160,800
DM available for use                254,000                324,400                384,800
Less Ending DM Inventory                102,000                120,400                144,000
Cost of DM in Production  $        2,280,000  $        3,060,000  $        3,612,000
DL  $            812,250  $        1,090,125  $        1,286,775
MOH  $      474,800.00  $      521,600.00  $      554,720.00
Total Manufacturing Costs  $        3,567,050  $        4,671,725  $        5,453,495
Total WIP during Period 0 0 0
Less Ending WIP 0 0 0
Cost of Goods Manufactured  $        3,567,050  $        4,671,725  $        5,453,495
Less Finished Goods Ending  $        1,808,005  $        1,880,797  $        2,134,444
Cost of Goods Sold  $        1,759,045  $        2,790,928  $        3,319,051  $        7,869,023

 

Boom Broom Manufacturing
Income Statement
For the Quarter Ending March 31
Jan Feb Mar Total
Sales Revenue  $        2,300,000  $        3,450,000  $        4,025,000  $        9,775,000
Cost of Goods Sold  $        1,759,045  $        2,790,928  $        3,319,051  $        7,869,023
Gross Profit  $            540,955  $            659,072  $            705,949  $        1,905,977
Selling and Administrative Expenses  $            315,200  $            385,400  $            435,080  $            915,680
operating Income  $            225,755  $            273,672  $            270,869  $            990,297
Tax Expense  $              56,439  $              68,418  $              67,717  $            247,574
Net Income  $            169,316  $            205,254  $            203,152  $            742,722
Gross Profit Margin 23.5% 19.1% 17.5% 19.5%
Profit Margin 7.4% 5.9% 5.0% 7.6%

 

Boom Broom Manufacturing
Cash Budget
For the Quarter Ending March 31
Jan Feb Mar Total
Opening Bal 50000         (1,217,050)         (2,438,775)  
Cash inflows
Sales Revenue  $        2,300,000  $        3,450,000  $        4,025,000  $        9,775,000
 $        2,350,000  $        2,232,950  $        1,586,225  $        9,775,000
Cash Outflows
Labor  $            812,250  $        1,090,125  $        1,286,775  $        3,189,150
Materials  $        2,280,000  $        3,060,000  $        3,612,000  $        8,952,000
Overheads  $            474,800  $            521,600  $            554,720  $        1,551,120
 $        3,567,050  $        4,671,725  $        5,453,495  $      13,692,270
Net Cash flow  $    (1,217,050)  $    (2,438,775)  $    (3,867,270)  $    (3,917,270)

 

You May Also Like

The deadline is near. Don’t worry. The Best Writer is here for Help.