BUS106 Accounting For Business and Labor Payments Assignment
Questions:
a. Cash budget
b. Materials budget
c. Labour budget
Answers:
Requirement 1:
a) Cash Budget: | |||||
Particulars |
January |
February |
March |
April |
TOTAL |
Projected Sales in units |
70000 |
90000 |
90000 |
100000 |
350000 |
Selling price per unit |
$25 |
$25 |
$25 |
$25 |
$25 |
Cash Receipts from Sales |
$1,750,000.00 |
$2,250,000.00 |
$2,250,000.00 |
$2,500,000.00 |
$8,750,000.00 |
Cash Payment to Supplier |
-$136,500.00 |
-$721,500.00 |
-$1,105,000.00 |
-$1,189,500.00 |
-$3,152,500.00 |
Labor Payments |
-$4,725,000.00 |
-$2,430,000.00 |
-$6,075,000.00 |
-$6,750,000.00 |
-$19,980,000.00 |
Overheads |
-$200,000.00 |
-$200,000.00 |
-$200,000.00 |
-$200,000.00 |
-$800,000.00 |
Cash Inflow(Outflow) from operation |
-$3,241,475.00 |
-$1,011,475.00 |
-$5,039,975.00 |
-$5,539,475.00 |
-$14,832,475.00 |
Add: Opening Balance |
$800,000.00 |
-$2,441,475.00 |
-$3,452,950.00 |
-$8,492,925.00 |
$800,000.00 |
Closing Balance |
-$2,441,475.00 |
-$3,452,950.00 |
-$8,492,925.00 |
-$14,032,400.00 |
-$14,032,475.00 |
b) Material Budget: | |||||
Particulars |
January |
February |
March |
April |
TOTAL |
Projected Sales (in Units) |
70000 |
90000 |
90000 |
100000 |
350000 |
Material A: |
|
|
|
|
|
Required per unit |
2 |
2 |
2 |
2 |
2 |
Material Cost per kg. |
$2.00 |
$2.00 |
$2.00 |
$2.00 |
$2.00 |
Cost for Material A |
$280,000.00 |
$360,000.00 |
$360,000.00 |
$400,000.00 |
$1,400,000.00 |
Material B: |
|
|
|
|
|
Required per unit |
2 |
2 |
2 |
2 |
2 |
Material Cost per kg. |
$1.50 |
$1.50 |
$1.50 |
$1.50 |
$1.50 |
Cost for Material B |
$210,000.00 |
$270,000.00 |
$270,000.00 |
$300,000.00 |
$1,050,000.00 |
Material C: |
|
|
|
|
|
Required per unit |
6 |
6 |
6 |
6 |
6 |
Material Cost per kg. |
$1.00 |
$1.00 |
$1.00 |
$1.00 |
$1.00 |
Cost for Material C |
$420,000.00 |
$540,000.00 |
$540,000.00 |
$600,000.00 |
$2,100,000.00 |
Total Material Cost |
$910,000.00 |
$1,170,000.00 |
$1,170,000.00 |
$1,300,000.00 |
$4,550,000.00 |
c) Labor Budget: | |||||
Particulars |
January |
February |
March |
April |
TOTAL |
Projected Sales in Units |
70000 |
90000 |
90000 |
100000 |
350000 |
Kgs. in per unit |
10 |
10 |
10 |
10 |
10 |
Projected Sales in Kgs. |
700000 |
900000 |
900000 |
1000000 |
3500000 |
Labor hours per kg |
0.25 |
0.25 |
0.25 |
0.25 |
0.25 |
Labor Cost per hour |
$27.00 |
$27.00 |
$27.00 |
$27.00 |
$27.00 |
Total Labor Cost |
$4,725,000.00 |
$2,430,000.00 |
$6,075,000.00 |
$6,750,000.00 |
$23,625,000.00 |
Workings:
Payment Schedule for Supplier: | |||||||
Particulars |
January |
February |
March |
April |
May |
June |
TOTAL |
|
|
|
|
|
|
|
|
Material Cost |
$910,000.00 |
$1,170,000.00 |
$1,170,000.00 |
$1,300,000.00 |
$2,210,000.00 |
$1,690,000.00 |
$8,450,000.00 |
|
|
|
|
|
|
|
|
Payment to Supplier: |
|
|
|
|
|
|
|
15% at the end of month |
$136,500.00 |
$175,500.00 |
$175,500.00 |
$195,000.00 |
$331,500.00 |
$253,500.00 |
$1,267,500.00 |
60% at the end of 2nd month |
|
$546,000.00 |
$702,000.00 |
$702,000.00 |
$780,000.00 |
$1,326,000.00 |
$4,056,000.00 |
25% at the end of rd month |
|
|
$227,500.00 |
$292,500.00 |
$292,500.00 |
$325,000.00 |
$1,137,500.00 |
|
|
|
|
|
|
|
|
Total Payment |
$136,500.00 |
$721,500.00 |
$1,105,000.00 |
$1,189,500.00 |
$1,404,000.00 |
$1,904,500.00 |
$6,461,000.00 |
Cash Budget:
Cash budget can be defined as the estimation of cash receipts and cash disbursements for a particular period in future. It includes the revenues, incomes and other sources of cash inflows and cash outflows, caused by expenses or debt repayments. Business firms prepare the cash budget to project the cash position and also to estimate the additional cash requirements for a certain period (Gitman et al. 2015).
The cash budget prepared for Smith & Co., exhibits that the company would face shortage of cash funds for the period from January to April. The cash receipts from sales would not be sufficient to cover its cash outflows for operation.
Material Budget:
Material budget is an estimation of the materials, which has to be purchased for completing the targeted production in a certain period. It provides both the volume of the materials, required, and the amount to be required for purchasing the budgeted volume of materials. It is very beneficial to maintain the stock levels properly so that the production would not be hampered for shortage of materials. Moreover, the management can also arrange the funds required for purchasing the required materials in advance accordingly.
Smith & Co. requires three different materials for manufacturing the final product. The material budget helps the company to ascertain the purchase cost of each material and the total purchase cost for every month. The material budget is also helpful for preparing the payment schedule for suppliers, which is, in turn, required for preparing the cash budget also.
Labor Budget:-
Labor budget is prepared for ascertaining the labor hours, required for producing a targeted volume of goods and the estimate the cost for obtaining the estimated labor hours. Certain organizations, which require different forms of direct labors, break down the direct labor hours and costs as per the different categories of labors to determine the labor costs for various labor categories (Klychova et al. 2014).
The labor budget of Smith & Co. would be very useful to prepare the cash budget and the master budget. It also indicates that the labor costs for manufacturing the budgeted production volume are very high than the projected sales revenue.
Recommended Changes:
It has been observed from the cash budget that Smith & Co. would have negative balance over the stated period. It indicates that the cash outflows for the stated period of the company are higher than the cash inflows. From further analysis of the budget, it has been noticed that the labor cost is too high in comparison to sales revenue and other expenses. The following recommendations are given to change the scenario:
Requirement 3:
Smith & Co. has received an order to sell 80,000 units at a special price of $25 per unit, whereas, the general selling price per unit of the product is $32 per unit. However, there are few factors, which should be considered to evaluate the proposal. The factors are discussed below
- Production Capacity: The management should measure its current production capacity and check whether the company can produce 80,000 units in addition to its current sales volume. If the production capacity is mower than the special order volume, then the order should not be accepted (Coates IV 2014).
- Affect on Normal Sales: The special order price per unit is lower than the normal selling price per unit. Hence, it must be ensured that the special order should not affect the current sales volume highly.
- Profit Volume: The management must compare its current profit volume with the expected profit, to be earned for accepting the order. If the profit for accepting order would be lower than the current profit volume, then it is better to avoid this offer (Anderson et al. 2015).
References:-
Anderson, D.R., Sweeney, D.J., Williams, T.A., Camm, J.D. and Cochran, J.J., 2015. An introduction to management science: quantitative approaches to decision making. Cengage learning.
Braun, K.W., Tietz, W.M., Harrison, W.T., Bamber, L.S. and Horngren, C.T., 2014. Managerial accounting. Pearson.
Coates IV, J.C., 2014. Cost-Benefit Analysis of Financial Regulation: Case Studies and Implications. Yale LJ, 124, p.882
DRURY, C.M., 2013. Management and cost accounting. Springer.
Gitman, L.J., Juchau, R. and Flanagan, J., 2015. Principles of managerial finance. Pearson Higher Education AU.
Klychova, G.S., Faskhutdinova, ?.S. and Sadrieva, E.R., 2014. Budget efficiency for cost control purposes in management accounting system. Mediterranean journal of social sciences, 5(24), p.79.
Buy BUS106 Accounting For Business and Labor Payments Assignment Answers Online
Talk to our expert to get the help with BUS106 Accounting For Business and Labor Payments Assignment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.