Calculate a flexed budget and a variance

Assignment Help Finance Basics
Reference no: EM133164607

Question: Delight Ltd is an established company which specialises in making celebration cakes for large events, birthdays, weddings and other celebrations. In the past they have grown steadily and have always achieved their budgeted sales targets. They have a good reputation, using fresh, high quality ingredients. However, during the year 2020, the global Covid-19 pandemic prevented many large celebrations from taking place, and the company's cake sales dropped significantly.

The Managing Director, Susan Thornton, wants to know which areas of her business have performed well in 2020 and has heard that using a flexed budget will help to identify this. She has asked you to review the 2020 financial results and advise her on actions which she could take to improve the company's performance in the coming year.

The results for 2020 are presented in the following table:

 

Actual

Budget

Sales units (Cakes)

85,000 units

110,000 units

 

 

 

 

£

£

Selling price per cake

35

40

 

 

 

Sales revenue

2,975,000

4,400,000

 

 

 

Direct materials

935,000

1,100,000

Direct labour

510,000

550,000

Gas (variable)

89,250

110,000

Electricity (fixed)

42,750

50,000

Production overhead

670,000

640,000

Selling & admin overhead

980,000

950,000

Total Costs

3,227,000

3,400,000

 

 

 

Profit / (loss)

(252,000)

1,000,000

 

 

 

The following notes are relevant:
• Direct materials include eggs, sugar and flour. These were in short supply in 2020, with eggs particularly difficult to obtain from their usual suppliers.
• The company kept all its staff working during the pandemic, but also needed to use some less experienced temporary staff to cover for employees who were unable to work due to Covid-19 infection or self-isolation.
• The gas is only used in the bakery ovens and normally costs £1 per cake baked.
• Electricity is budgeted at £50,000 per year. The charge covers head office electricity as well as general light and heat of buildings.
• Production overhead and selling& admin overhead are fixed costs.
• Production overhead includes depreciation, machine maintenance and production manager salaries. Some temporary staff have been used to cover sickness during the year.
• Selling and admin overhead includes advertising costs, finance, sales team and other management salaries. Some temporary staff have been used to cover sickness during the year.
• Some Head Office employees worked from home during the year.

Budget process
The company has always previously used an incremental budgeting methodology to calculate its budget for the coming year. An external consultant has proposed that they change to use zero based budgeting for the future. Susan is not sure what this means or whether it will make their budgeting more accurate. She has asked you to advise her.

Required:

a) For each category of the 2020 results, calculate a flexed budget and a variance to the flexed budget. (The variance to the flexed budget is the variance between the Actual results and the flexed budget results).

b) Based on your calculations in part (a), and the additional relevant information provided in the question, state for each category of the results what the possible causes could be of the flexed variance to budget, and a possible action management could take.

c) Critically analyse both zero based budgeting and incremental budgeting methodologies, with specific reference to Delight Ltd, and the current and future economic situation of their industry. Advise Susan, the Managing Director, on whether zero based budgeting is an appropriate methodology for her business, giving your reasoning.

Reference no: EM133164607

Questions Cloud

Enormous installed base of printers in customer organization : Hewlett-Packard (H-P) has enormous installed base of printers in customer organizations, large and small, all over the world.
Creates the content published in social channels : Who creates the content published in social channels? How do social media marketers utilize SEO and SMO to meet marketing objectives?
Expansion by increasing penetration of current product : "Expansion by Increasing Penetration of Current Product-Markets," is this a strategy Samsung has used? Explain why or why not.
What is fisher investment in current assets : Question - The Fisher Apparel Company balance sheet for the year ended Year 1 is as follows: What is Fisher's investment in current assets
Calculate a flexed budget and a variance : Calculate a flexed budget and a variance to the flexed budget. (The variance to the flexed budget is the variance between the Actual results and the flexed
Customers in business target segment : Which of those competencies best match the needs and wants of the customers in the business's target segment(s)?
Develop private-label brands for amazon : Why is Amazon pushing national-brand manufacturers to develop private-label brands for Amazon?
Analysing firms financial performance and position : Briefly explain the information contained in the cash flow statement and its relevance in analysing firm's financial performance and position
Explain how this transfer of receivable should be treated : If Air Inc. follows ASPE, explain how this transfer of receivable should be treated by the company? Explain why

Reviews

Write a Review

Finance Basics Questions & Answers

  What will the account balance be after 17 ?years

Suppose that when your friend was? born, your? friend's parents deposit $5000 in an account paying 5.9?% interest compounded quarterly.

  Determining the distribution of the number of customers

What is the distribution of the number of customers at any given time (T=M+F)

  Explain the rational-logic of capital asset pricing model

Explain the rational / logic of the Capital Asset Pricing Model (CAPM), and explain how one can use it in the estimation of a firm's cost of equity capital.

  What is the year 1 net operating cash flow

Using the information from problem 1 on Large Manufacturing, Inc., what is the Year 1 Net Operating Cash Flow?

  Derive the portfolio metrics

Assume each security has a face value of $100 and pays coupons semi-annually. Derive the portfolio's metrics:

  Strategy or tactics applied by the company in offering it

How do you think business buyer behavior can have an impact on the strategy or tactics applied by the company in offering it?

  What is the maximum amount

Your company has the opportunity to make an investment that promises to pay $24,000 after 6 years. If your company has a required return of 8.5% on this type of investment, what is the maximum amount that the company should pay for the investment? Ex..

  Project equivalent annual cost or eac

A five-year project has an initial fixed asset investment of $305,000, an initial NWC investment of $29,000, and an annual OCF of -$28,000.

  Determine the market value of the operation ignoring taxes

an oil company has paid 100000 for the right to pump oil on a plot of land during the next three years. a well has

  What is total cost of installed ductwork for this project

In a building construction project, 7,500   feet of insulated ductwork is required. The ductwork is made from 14-gauge steel costing $8.50 per pound. What is the total cost of the installed ductwork for this project

  Calculate the npv and decide if the system

Calculate the NPV and decide if the system is worth installing if the required rate of return is 8%.

  Explain the differences in potential risk and return

Duve, Inc. desires to penetrate a foreign market with either a licensing agreement with a foreign firm or by acquiring a foreign firm. Explain the differences in potential risk and return between a licensing agreement with a foreign firm and the acqu..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd