Prepare a flexible budget report for the year

Assignment Help Managerial Accounting
Reference no: EM131639254

Case Study 1

Montana Farm is a 400-acre farm on the outskirts of San Bernardino Plains, one of the major suppliers free range eggs in the country. A recent breakout of bird flu in the Asia pacific region has affected the industry amid health concerns which has led to a decline with the demand, and it has made the business extremely competitive. To meet the competition, Montana Farm planned in 2017 to advertise more extensively, boost health of laying hens with regular monitoring of veterinary specialists and sourcing grain from trusted suppliers.

The budget report for 2017 is presented below. As shown, the static income statement budget for the year is based on an expected 69,000 laying hens producing 568,100 dozen of eggs at $3.95 per dozen.

The variable expenses were budgeted as follows:

Per laying hen: feed $1.05, nutrition $0.12, supplies $0.06

Per dozen eggs produced: delivery $0.30

All other budgeted expenses were either fixed or mixed expenses.

During the year, management decided not to replace a farm hand who quit in March, but it did issue a new advertising brochure and paid for more promotion and advertising.

MONTANA FARM

 

 

 

Static Budget Income Statement

 

 

For the Year Ended December 31, 2017

 

 

 

 

Actual

Master

Difference

 

 

Budget

 

 

 

 

 

Number of laying hens

65,423

69,000

3,577

U

 

 

 

 

 

 

 

 

 

 

 

 

Number of dozen eggs produced

510,299

568,100

 

 

Sales

$1,939,138

$2,243,995

304,857

U

Less: Variable expenses

 

 

 

 

 

 

 

 

Feed

840,031

869,400

29,369

F

Nutrition

109,911

99,360

10,551

U

Supplies

62,806

45,540

17,266

U

Delivery expenses

153,090

170,430

17,340

F

 

 

 

 

 

 

Total variable expenses

1,165,838

1,184,730

18,892

F

 

 

 

 

 

 

Contribution margin

773,300

1,059,265

285,965

U

 

 

 

 

Less: Fixed expenses

 

 

 

 

Depreciation

60,000

60,000

0

F

Insurance

69,000

69,000

0

F

Utilities

62,000

58,000

4,000

U

Repairs and maintenance

30,000

25,000

5,000

U

Salary and wages

216,000

230,000

14,000

F

Delivery expenses

 

 

0

F

Veterinary fees

87,000

75,900

11,100

U

Advertisement

120,000

105,000

15,000

U

Entertainment

7,000

5,000

2,000

U

 

 

 

 

 

 

Total fixed expenses

651,000

627,900

23,100

U

 

 

 

 

 

 

Net income

122,300

431,365

309,065

U

Instructions

(a) Based on the static budget report:

1. What was the primary cause(s) of the loss in net income?

2. Did management do a good, average, or poor job of controlling expenses?

3. Were management's decisions to stay competitive sound?

(b) Prepare a flexible budget report for the year.

(c) Based on the flexible budget report, answer the three questions in part a above.

(d) What course of action do you recommend for the management of Montana Farm?

Case Study 2

You are the management accountant at Luxe Fashion Retail Limited (LFR) reporting to the CFO, Mark Newson.

LFR is a company listed on the Australian Securities Exchange. LFR has eight stores across Australia and New Zealand, with its flagship store situated in central Melbourne. Its stores stock luxury clothing, footwear and accessories, as well as cosmetics and beauty products for both men and women.

LFR's strategy is to be the leading retailer of luxury goods in Australia and New Zealand, providing the best of life's luxuries to customers and a superior return to shareholders as it continues to expand and grow the business.

The company has a reputation for stocking the best quality and range of products. Careful consideration is given at a senior management level to the product lines and brands stocked, to ensure that the company's reputation is maintained. The following information is provided to assist you with completing the tasks below.

Product range

LFR stocks an extensive range of many well-known luxury brands (e.g. Chanel, Gucci and Burberry). It also stocks a number of lines under exclusive agreements with suppliers, ensuring it is the sole local retailer. As a result, approximately 30% of product stocked by LFR is not available anywhere else in Australia or New Zealand. LFR head office employs a highly skilled buyer to manage its stock lines and to determine customer pricing. Although the company does stock a number of locally designed and made product lines, the majority of its stock is imported

Purchasing

A key area of focus for the board relates to the purchasing of stock. Depending on the nature of the product, lead times between placing a non-cancellable order and receiving the stock can be significant. For example, clothing collections often need to be ordered 12 months in advance.

In-store experience

Similarly, the in-store experience of customers is considered pivotal for LFR, particularly in light of the increasing popularity of online retailers. Sales staff are trained to provide a personalised shopping experience for each customer. Many of the sales staff have developed close relationships with their customers who they have been serving for many years, and who buy most of their wardrobes from LFR. The ambience of the store, which refreshes its displays regularly, is seen as critical to attracting new customers and retaining existing customers. High-value existing customers are issued with a LFR gold privileges card and their preferences are recorded in a customer database. While in the store, they are served coffee or champagne. All other customers are offered a bronze privileges card, if they do not show a card at time of purchasing.

Store manager responsibilities

Each of the eight stores is run by an experienced store manager. They are responsible for the store opening hours, store layout and design display, resupply of stock from the central warehouse, staff management and the customer experience while in the store.

Instructions

For this activity you are required to complete the following tasks:

1. Develop a balanced scorecard for LFR at the organisation level by:

a) Identifying at least one LFR's strategic objectives in each of the perspectives (i.e. financial, customer, internal process, and learning and growth).

b) Developing a measure in the form of a KPI for each objective identified. Use the template below in completing task 1

2. Now apply the balanced scorecard you have developed at the store level. (You

have recognised that the measures appropriate for each store may differ from those developed at the organisational level.)

a) Describe why internal perspective measures that are appropriate at an organisational level may not be appropriate at an individual store level.

b) Develop two (2) new KPIs which would be appropriate to include in the internal process perspective of a balanced scorecard for the individual stores.

c) For each measure included explain how it links back to LFR's strategy. Use the template below in completing task 2 b and c

Verified Expert

"The assignment involves preparation of flexible budget form the static budget provided by the Montana firm and establish exactly why the deviations and variations took place and involves a discussion of the measures taken by the firms management to control costs and adhere to the budget. The paper is prepared in Microsoft word with Harvard referencing".

Reference no: EM131639254

Questions Cloud

What is the probability of winning : If you bet on "red," you win if the ball lands in a red slot. What is the probability of winning?
What is the sum of the given probabilities : What is the sum of these probabilities? Why do you expect the sum to have this value?
Discuss the diabetic patients medical details : description of the case that you selected including the diabetic patient's medical details
Suggest at least three policy changes that you believe : Suggest at least three policy changes that you believe the law enforcement intelligence community should make in order to increase their effectiveness.
Prepare a flexible budget report for the year : What was the primary cause(s) of the loss in net income - Prepare a flexible budget report for the year - Develop a balanced scorecard for LFR
Why is marketing research is such an attractive career today : Describe ways that observation is used to create data for marketing research? Why is marketing research is such an attractive career today?
How should toyota market itself to regain consumer trust : How should Toyota market itself to regain consumer trust that has been shaken by the many deaths that resulted because of the initial gas pedal defect?
Define a cultural connection related to food intake : Do you think that the CAD issue might have a cultural connection related to food intake. Some cultural traditions tend to have a higher fat content than others.
Probability that the son moves to one of the higher classes : Moving up. A sociologist studying social mobility in Denmark finds that the probability that the son of a lower-class father remains in the lower class is 0.46.

Reviews

inf1639254

11/14/2017 4:50:37 AM

This is for Australian University and its Managerial Accounting. I appreciate if this can be done before the proposed due date? Thanks for your support. I am happy to order again. Great work done by expert.....Good work as ever, you guys always help.. good job keep it up...............................................

len1639254

9/13/2017 1:36:25 AM

Will be graded on the following criteria: Accuracy - o Content o Correct account names etc. o Correct values Presentation o Accounting protocols o Spelling During the year, management decided not to replace a farm hand who quit in March, but it did issue a new advertising brochure and paid for more promotion and advertising.

Write a Review

Managerial Accounting Questions & Answers

  About the permanent account

An adjusting entry will not take the format of which one of the following entries? Which of the following is a permanent account?

  Traditional activity-based costing

Analyze the major benefits and major weaknesses of traditional Activity-Based Costing (ABC) in determining accurate overhead cost over a time-driven

  Why does just-in-time require total quality management

How could control charts be used? Give two examples. Why does just-in-time require total quality management? Why is time important in a competitive environment?

  This chapter explained that many companies

Based only on the information in the statements of cash flows, does Sirius XM appear to be growing the capacity of its business? Explain.

  Pick any large company and explain three ways

Pick any large company and explain three ways that it could segment its company wide performance.

  Comment on palmer efficiency in using its assets

Comment on Palmer's efficiency in using its assets to increase sales from 2012 to2013.

  Provides a summary and a reaction to the choosen article

Find an article that is related to using managerial accounting information. Write a 750 - 1,000 word paper that provides a summary and a reaction to the article.

  Notaro''s boot company makes specialty boots

Notaro's Boot Company makes specialty boots for the rodeo circuit. On December 31, 2012, the company had

  Compute the cost of each model

S. Lee Enterprises produces two models of lawn tractor: SL1 and SL2.

  What are the direct material and direct labour price

Calculate a) net book value of the equipment at the end of the third year using the straight-line method of depreciation; and b) depreciation expense for the second year using the double-declining balance method of depreciation.

  Bunn operates a small family bakery

It has recently moved into new premises and has invested in more advanced equipment, with the aim of making the baking process more automated.

  General views regarding interperiod income tax allocation

There are 3 general views regarding interperiod income tax allocation: no allocation, partial allocation, and comprehensive allocation. Defend the position of an allocation of your choice (no allocation, partial or comprehensive allocation).

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