Budget comparative Analysis-70744

Answer No 2

  Question_2_iquestion_2ii

Question 2 (iii)

  1. Price being the significant factor for which the consumers are shifting from Teasermalt to Chockoball reduction in price by $ 0.4 Teasermalt will gain the better market share thus the sales volume will increase by 25%. Though the company has managed to get savings in prime cost but this saving could not cover up the losses due to reduction in price thus the organization has to suffer loss of $ 0.4030 per unit sold. Despite increase in volume of sales the product could not achieve the target ROTA of 25%. Thus the strategies introduced by the company are not worthy enough to reach the target of 25% return on total assets.
  2. In the Second part of the question where the cost structure of the Chockoball is given the decreased market share has hurt the profitability of the company as the fixed cost in the logistics is intact at $ 35,100,000 which cannot be compensate with the sales decreased. The reduced profitability will gain the teasermalt a better market and will help the product gain consumers. The non shifting of the consumers will let the teasermalt survive the market. 75% decrease in the market will hurt the chockoball market share to a great extent. In future it might be so where teaser,malt will make the chockoball extinct from the market.
  3. The company should not go with the recommended changes since it is suffering losses due to this. However by this changes company may extinct its competition of chockoball but in that process company will have to suffer huge losses. The company can go with the recommendations only along with some additional strategic actions such as reducing the supermarket retail margins or increasing the supermarket rebates. Such strategies will increase the net sale value of the company thus reducing the losses and converting it to profits for the company.

 

Answer No 3

 

To The management

 

It can be seen that the management was not able to complete the demand of the company using its production capacity and its the reason for the slow growth of the company in the recent years and hence the changes in the production capacity would be helpful for the company and hence the demand could be met but as this would also lead to the increase in the costs of the company as the fixed overheads and hence the same should be feasible by the analysis performed of the company.

The analysis performed could be analyzed as the company would be better off if the company selects the option to extend the 30% of the production line which would ensure profitability of the company and help the company to recover the investment by the increase of the profit margins of the company. Hence this would be profitable or the company to enhance the productive capacity by 30% and it would help the company to increase by 23.45 million dollars for the company.

The other issues that would be considered by the manager are the various strategic changes that it to do with management of the various resources that are increasing with the time and thus would be a major drawback before any decision can be made by the company on the extension of the project.

Answer 4

This allocation is important as this wil only help the management accountants to appropriate costs to the various departments that produce goods and then these can be divided to various costs of the goods that would be the main objective of the process. The analsyis is important to understand the best method under which the goods can be allocated in the various ratios to the different items and

 

Answer 5

 

The major line of difference between the actual costing and normal costing are the way in which the costs are allocated to the various products and services and the manner in which they are calculated. The normal cost of the product consists of the direct materials costs of the products, direct labour and the standard overheads costs calculated at a predetermined overheads for the products based on the hours or machine time etc. In the case of actual costing the total costs consist of the actual materials costs of the goods, labour charge of the goods and the overheads are calculated using the allocation method such as actual labour hours or machine hours of the system. Hence the best possible task is to allocate it on actual and hence the actual method is more realistic than the normal costing method of costing.  (SUNILKUMAR, 2012)

 

Answer 6

 

To The Managing director

The decision of production is mainly based on the concept that what would be the correct product that   would bring maximum profits for the enterprise and that would help the management to make the decision correctly. In the given case that the tradition methods that was followed and had helped the management to go for eco products proved to be wrong when actual decision was taken by the ABC method and it seemed that the profits are more in the normal ones as the overheads are mostly consumed by the eco divisions and this model would be not a profitable product as the analysis indicates. It means that the wrong recovery of the overheads to the other product is the reason for the incorrect decision and hence should be thought strategically and decided upon and hence the costs allocations can change decisions to the great extent.

Food Masters Australia Cost of Good manufactured Schedule For the Year Ended Dec 31 2014

Particulars Amount Amount
Direct Materials Used     Food masters Income Statement For the period ending Dec 31 2014
Op RM  $                  124,000     Particulars Amount
Add Puchase of Materials  $              6,387,000     Sales  $          19,585,000.00
Total Raw Mat Avail  $              6,511,000     Less Of Goods Sold  $          11,653,000.00
less Closing RM  $                    20,500     Gross Margin  $            7,932,000.00
Total Materials Used    $          6,490,500 Less Expenses  
Freight Inwards    $                68,000   Marketing Exp  $            1,225,000.00
Direct Labour  $              1,429,000  $          1,429,000   Accounting costs  $                206,000.00
Manufacturing Overhead       Interest & other finance charges

 $            750,000.00

Indirect Labour  $                  276,000     Dep of office Eq  $                  38,000.00
Manufacturing Overhead  $              1,852,000     Heat costs  $                250,000.00
Depreciation  $              1,250,000     Office Salaries  $                246,000.00
heat and Light  $                  750,000     freight Outs  $                482,000.00
Total maufacturing overheads    $          4,128,000   Total expenses  $            3,197,000.00
Total Factory costs    $        12,115,500   Income before tax  $            4,735,000.00
Add Op WIP       Tax @ 30% assumed  $            1,420,500.00
Mat  $                    17,500     Income After Tax  $            3,314,500.00
Labour  $                      4,000  
Overhead  $                      5,000  $                26,500
Less Cl WIP    
Mat  $                    20,500  
Labour  $                      5,000  
Overhead  $                      6,500  $                32,000
     
Cost Of Goods Manufactured    $        12,110,000
Schedule of Good Sold    
     
Cost Of Goods Manufactured    $        12,110,000
Add Opening FG    $              650,000
less Closing FG    $          1,107,000
Cost of Goods Sold    $        11,653,000
Food masters Income Statement For the period ending Dec 31 2014
  Particulars Amount
  Sales  $  19,585,000.00
  Less Of Goods Sold

#REF!

  Gross Margin

#REF!

Less Expenses  
  Marketing Exp  $    1,225,000.00
  Accounting costs  $        206,000.00
  Interest & other finance charges

 $      750,000.00

  Dep of office Eq  $          38,000.00
  Heat costs  $        250,000.00
  Office Salaries  $        246,000.00
  freight Outs  $        482,000.00
  Total expenses  $    3,197,000.00
  Income before tax

#REF!

  Tax @ 30% assumed

#REF!

  Income After Tax

#REF!

Q4
Answer To Question 4
Allocation Of Costs under Direct Method
Total Costs Incurred in Maintenance

472000

Allocation of Miantenance
No of Jobs in Manufacturing and Assembly Jobs Costs Allocation Self Costs Total Costs
Manufacturing

265

367882

910000

1277882

Assembly

75

104118

175000

279118

Total Costs Incurred in Robotics

675000

Allocation of Robotics
No of Jobs in Manufacturing and Assembly Machines Costs Allocation Self Costs Total Costs
Manufacturing

16

158824

1277882

1436706

Assembly

52

516176

279118

795294

Allocation Of Costs under Step Down Method
Total Costs Incurred in Maintenance

472000

Allocation of Miantenance
No of Jobs  done except for self Jobs Costs Allocation Self Costs Total Costs
Manufacturing

265

339891

910000

1249891

Assembly

75

96196

175000

271196

Robotics

28

35913

0

35913

Original Allocated Total
Total Costs Incurred in Robotics

675000

35913

710913

Allocation of Robotics
No of Jobs in Manufacturing and Assembly Machines Costs Allocation Self Costs Total Costs
Manufacturing

16

167274

1249891

1417165

Assembly

52

543639

271196

814835

Step Down Table
  Mainte Robo Manu Asse
 

472000

675000

910000

175000

Allocated To 3 depts

-472000

35913

339891

96196

Allocated to remaining departments  

-710913

167274

543639

 

0

0

1417165

814835

Allocation of Costs under reciprocal method
calculation of percentages
Department

No. of Maintenance Jobs

No. of Robotic Machines

Percentage Percentage
Manufacturing

265

16

0%

#DIV/0!

Assembly

75

52

0%

#DIV/0!

Maintenance

42

10

0%

#DIV/0!

Robotics

28

12

0%

#DIV/0!

 

410

90

   
Equations
Maintenance=472000+11% of Robotic Allocation
Robotic= 675000+7% of Maintenance   Mainte Robo Manu Asse
By solving  

472000

675000

910000

175000

X=550500 Allocation of Maintenance

-550500

38535

708

99090

Y=713535 Allocated Of Robo

78500

-713535

#DIV/0!

#DIV/0!

 

0

0

#DIV/0!

#DIV/0!

Impact
These allocation is important as this wil only help the  management accountants to appropriate costs to the various departments that produce goods and then these can be divided to various costs of the goods that would be the main objective of the process. The analsyis is important to understand the best nethod under which the goods can be allocated in the various ratios to the different items and
Q6
Answer To Question No 6
Calculation Under Existing System Of Allocation     Calculation Under ABC  System Of Allocation  
Particulars Standard EcoFree Particulars Standard
Sales Price Per Unit

300

450

Sales Price Per Unit

300

Prime Costs per unit

120

180

Prime Costs per unit

120

Overheads per unit

100

100

Overheads per unit

75

(10*10)     (10*10)  
GP per unit

80

170

GP per unit

105

GP%

26.7

37.8

GP%

35.0

Total Gp per model                  8,000,000               1,700,000 Total Gp per model                    10,500,000
         
Firm’s GP                  9,700,000   Firm’s GP                       9,700,000
Note
Caclulation of the Allocation of the Overhead per unit as per ABC
Overhead Type Amt Total Allocation per unit Standard Eco
Machining Set Ups

2000000

300

6667

666667

1333333

Laser Cutter

2000000

200000

10

1500000

500000

Assembly

5000000

125000

40

4000000

1000000

Packing

2000000

1500

1333

1333333

666667

Total $ Overhead

11000000

 

7500000

3500000

Per Unit

75

350

Q3

Cat n Kitty

Sales Budget

For the years Ending 2019

Year

2015

2016

2017

2018

2019

Particulars          
Budgeted Units To Be Sold(million)

50.76

53.6787

55

55

55

Price Per Unit

5.71

5.92

6.14

6.37

6.61

Total Gross Sales (million)

289.64925

317.7904849

337.8234

350.4918

363.6351912

Production Budget

For the years Ending 2019

year

2015

2016

2017

2018

2019

Particulars          
Sales In Units

50.76

53.6787

55

55

55

Desired Inventory Closing

0.976153846

1.032282692

1.057692

1.057692

1.057692308

Total Units needed

51.73615385

54.71098269

56.05769

56.05769

56.05769231

Units In hand opening

0.985

0.976153846

1.032283

1.057692

1.057692308

Production (Units)

50.75115385

53.73482885

55.02541

55

55

Purchase Budget

For the Half year ended 30June 2015

year

2015

2016

2017

2018

2019

Particulars          
Production (Units)

50.75115385

53.73482885

55.02541

55

55

value of Materials needed

117.3303238

127.6444831

134.3047

137.9344

141.7275763

Ending Inventory

2.256352381

2.454701599

2.582783

2.652584

2.725530314

Total Required

119.5866762

130.0991847

136.8875

140.587

144.4531066

Materails In hand opening

2.475

2.256352381

2.454702

2.582783

2.652584247

Purchase Value (miilion)

117.11

127.84

134.43

138.00

141.80

Particulars

2015

2016

2017

2018

2019

Direct Materials Used    
Op RM  $                  2.47500  $              2.25635  $2.45470  $2.58278  $                                                    2.65258
Add Puchase of Materials  $             117.11168  $         127.84283

########

########

 $                                               141.80052
Total Raw Mat Avail  $             119.58668  $         130.09918

########

########

 $                                               144.45311
less Closing RM  $                  2.25635  $              2.45470  $2.58278  $2.65258  $                                                    2.72553
Total Materials Used  $             117.33032  $         127.64448

########

########

 $                                               141.72758
Direct Labour  $                         7.90  $                     8.59  $       9.04  $       9.29  $                                                           9.54
Manufacturing Overhead    
Manufacturing Overhead                    51.49498                56.02175  58.94485  60.53787                                                      62.20266
Salaries  $                      1.361  $                   1.399  $    1.437  $    1.477  $                                                        1.517
Depreciation  $                           2.5  $                       2.5  $         2.5  $         2.5  $                                                             2.5
Cost Of Goods Manufactured  $                    180.59  $                196.16  $  206.23  $  211.74  $                                                      217.49
Schedule of Good Sold          
Particulars

2015

2016

2017

2018

2019

Cost Of Goods Manufactured  $                          181  $                      196  $        206  $        212  $                                                            217
Add Opening FG

3.340

3.473

3.768

3.964

4.072

less Closing FG

3.473

3.768

3.964

4.072

4.183

Cost of Goods Sold  $                    180.45  $                195.86  $  206.03  $  211.63  $                                                      217.38
Notes
Calculation of costs per unit
Particulars

2015

2016

2017

2018

2019

Units

50.7512

53.7348

55.0254

55.0000

55

Material

2.3119

2.3755

2.4408

2.5079

2.576865024

Labour

0.1557

0.1599

0.1643

0.1689

0.173508912

Overheads

1.0147

1.0426

1.0712

1.1007

1.130957427

Salaries

0.0268

0.0260

0.0261

0.0269

0.027590676

Depreciation

0.0493

0.0465

0.0454

0.0455

0.045454545

Costs Per Unit

3.5583

3.6505

3.7479

3.8498

3.954376584

Value of Inventory

3.47343184

3.768364132

3.964132

4.07186

4.182513695

`
Cat n Kitty

Income Statement For the period ending Dec 31 2019

Particulars

2015

2016

2017

2018

2019

Sales  $                    289.65  $                317.79  $  337.82  $  350.49  $                                                      363.64
Less Of Goods Sold  $                    180.45  $                195.86  $  206.03  $  211.63  $                                                      217.38
Gross Margin  $                    109.20  $                121.93  $  131.79  $  138.86  $                                                      146.26
Expenses          
Marketing Exp  $                      10.79  $                   11.08  $    11.39  $    11.70  $                                                        12.02
Interest & other finance charges

 $                  5.63

 $                     5.78  $       5.94  $       6.10  $                                                           6.27
Non Fcatory  $                         3.45  $                     3.54  $       3.64  $       3.74  $                                                           3.85
Total expenses  $                      19.86  $                   20.41  $    20.97  $    21.54  $                                                        22.14
Income before tax  $                      89.34  $                101.52  $  110.82  $  117.32  $                                                      124.12
Tax @ 30%  $                      26.80  $                   30.46  $    33.25  $    35.20  $                                                        37.24
Income After Tax(miilions)  $                      62.53  $                   71.06  $    77.57  $    82.12  $                                                        86.88
Q3(2)

Cat n Kitty

Sales Budget

For the years Ending 2019

Year

2015

2016

2017

2018

2019

Particulars          
Budgeted Units To Be Sold(million)

50.76

53.6787

56.76523

60.02923

63.48090618

Price Per Unit

5.71

5.92

6.14

6.37

6.61

Total Gross Sales (million)

289.64925

317.7904849

348.6658

382.5409

419.7071174

Production Budget

For the years Ending 2019

year

2015

2016

2017

2018

2019

Particulars          
Sales In Units

50.76

53.6787

56.76523

60.02923

63.48090618

Desired Inventory Closing

0.976153846

1.032282692

1.091639

1.154408

1.220786657

Total Units needed

51.73615385

54.71098269

57.85686

61.18363

64.70169284

Units In hand opening

0.976153846

1.032282692

1.091639

1.154408

1.220786657

Production (Units)

50.76

53.6787

56.76523

60.02923

63.48090618

Purchase Budget

For the Half year ended 30June 2015

year

2015

2016

2017

2018

2019

Particulars          
Production (Units)

50.76

53.6787

56.76523

60.02923

63.48090618

value of Materials needed

117.350775

127.5111518

138.5512

150.5472

163.5817268

Ending Inventory

2.256745673

2.452137534

2.664447

2.895138

3.145802439

Total Required

119.6075207

129.9632893

141.2157

153.4423

166.7275293

Materails In hand opening

2.475

2.256745673

2.452138

2.664447

2.89513779

Purchase Value (miilion)

117.13

127.71

138.76

150.78

163.83

Particulars

2015

2016

2017

2018

2019

Direct Materials Used    
Op RM  $                  2.47500  $              2.25675  $2.45214  $2.66445  $                                                    2.89514
Add Puchase of Materials  $             117.13252  $         127.70654

########

########

 $                                               163.83239
Total Raw Mat Avail  $             119.60752  $         129.96329

########

########

 $                                               166.72753
less Closing RM  $                  2.25675  $              2.45214  $2.66445  $2.89514  $                                                    3.14580
Total Materials Used  $             117.35078  $         127.51115

########

########

 $                                               163.58173
Direct Labour  $                         7.90  $                     8.59  $       9.33  $    10.14  $                                                        11.01
Manufacturing Overhead    
Manufacturing Overhead                    51.50395                55.96323  60.80859  66.07348                                                      71.79420
Salaries  $                      1.361  $                   1.399  $    1.437  $    1.477  $                                                        1.517
Depreciation  $                           2.5  $                       4.5  $         4.5  $         4.5  $                                                             4.5
Cost Of Goods Manufactured  $                    180.62  $                197.96  $  214.63  $  232.73  $                                                      252.41
Schedule of Good Sold          
Particulars

2015

2016

2017

2018

2019

Cost Of Goods Manufactured  $                          181  $                      198  $        215  $        233  $                                                            252
Add Opening FG

3.340

3.473

3.807

4.127

4.476

less Closing FG

3.473

3.807

4.127

4.476

4.854

Cost of Goods Sold  $                    180.48  $                197.63  $  214.31  $  232.39  $                                                      252.03
Notes
Calculation of costs per unit
Particulars

2015

2016

2017

2018

2019

Units

50.76

53.6787

56.76523

60.02923

63.48090618

Material

2.3119

2.3755

2.4408

2.5079

2.576865024

Labour

0.1557

0.1599

0.1643

0.1689

0.173508912

Overheads

1.0147

1.0426

1.0712

1.1007

1.130957427

Salaries

0.0268

0.0261

0.0253

0.0246

0.023904624

Depreciation

0.0493

0.0838

0.0793

0.0750

0.070887457

Costs Per Unit

3.5583

3.6879

3.7809

3.8770

3.976123444

Value of Inventory

3.473418896

3.806903989

4.127429

4.475661

4.853998448

`
Cat n Kitty

Income Statement For the period ending Dec 31 2019

Particulars

2015

2016

2017

2018

2019

Sales  $                    289.65  $                317.79  $  348.67  $  382.54  $                                                      419.71
Less Of Goods Sold  $                    180.48  $                197.63  $  214.31  $  232.39  $                                                      252.03
Gross Margin  $                    109.16  $                120.16  $  134.36  $  150.15  $                                                      167.68
Expenses          
Marketing Exp  $                      10.79  $                   11.08  $    11.39  $    11.70  $                                                        12.02
Interest & other finance charges

 $                  5.63

 $                     5.78  $       5.94  $       6.10  $                                                           6.27
Non Fcatory  $                         3.45  $                     3.54  $       3.64  $       3.74  $                                                           3.85
Total expenses  $                      19.86  $                   20.41  $    20.97  $    21.54  $                                                        22.14
Income before tax  $                      89.30  $                   99.76  $  113.39  $  128.61  $                                                      145.54
Tax @ 30%  $                      26.79  $                   29.93  $    34.02  $    38.58  $                                                        43.66
Income After Tax(miilions)  $                      62.51  $                   69.83  $    79.37  $    90.03  $                                                      101.88  $                        403.62
Without Extension of 30%
Income After Tax(miilions)  $                      62.53  $                   71.06  $    77.57  $    82.12  $                                                        86.88  $                        380.18
Increase  $                       -0.02  $                   -1.23  $       1.80  $       7.90  $                                                        15.00  $                           23.45