Prepare a flexible budget report for the year

Assignment Help Managerial Accounting
Reference no: EM131650096

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 per month: 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 task consists of two parts A and B. Part A deals with the static and flexible budget and their interpretation. These budgets have been applied for evaluating the performance of the company. Part B consists of Balanced Scorecard Approach where the balanced scorecard is prepared for a company and analyzed from various perspectives along with the discussion on KPI.

Reference no: EM131650096

Questions Cloud

What was the margin of error of the given poll : Polling disclaimer. A newspaper article that reported the results of an election poll included the following explanation.
Discuss how it trains ics and nims personnel : describe in detail purpose behind the "National Integration Center (NIC) and how it trains ICS and NIMS personnel
Sugging is bad for the research industry : Sugging is bad for the research industry and the reason is because there is a lot of fake research data and studies.
Analyzing opportunities for organizational development work : From what you read in the "Analyzing Opportunities for Organizational Development Work at Northern County Legal Services"
Prepare a flexible budget report for the year : ACT502 - Prepare a flexible budget report for the year and What was the primary causes of the loss in net income - management of Montana Farm
Accident rate is lower for girls than for teens in general : One insurance company found that the driver was a teenage girl in 44 of the 388 fatal accidents they investigated.
What is the proper scope for a search incident to arrest : What is the proper scope for a search incident to arrest, officers arrived at Bobby Sheen's house with a valid warrant for his ARREST
What senior community centers offer for elderly community : Explain in detail what Senior Community centers offer for the Elderly community.
What other capital budgeting approaches could be taken : discuss and describe what other capital budgeting approaches could be taken to allow for the increased riskiness of the estimated future cash flows

Reviews

inf1650096

12/18/2017 5:14:18 AM

HI is it possible for you to send the calculations as the same has to be given by me to the examiner and will also make it easier for me to understand the things. ACT502 Written Assessment S2217.doc The assignment was done according to the required instructions and intact it was done methodically and i am very satisfied with it, Infact it was ready before the deadline. I would recommend this site to everyone else.

Write a Review

Managerial Accounting Questions & Answers

  What should lance prating do

What should Lance Prating do?Explain. Do you remember that milling machine that broke down because the wrong lubricant was used by the machine operator?

  Isaiah''s return on total assets

Isaiah's return on total assets and beginning merchandise inventory and the average net receivables during the period are $400,000. What is the amount of net credit sales for the period?

  Work before seeing diminishing returns

How many hours can you work before seeing Diminishing Returns?

  Find the sloshs total dollar sales

Slosh expects to have $18,000 in fixed expenses next year. What would Slosh's total dollar sales have to be next year to generate a profit of $90,000?

  Merits and demerits of standard costing

What are the advantages and disadvantages of standard costing in management accounting?

  Budgeting and budgetary control

Literature synthesis with gaps and research opportunities (The literature synthesis must not lack specificity and theoretical debate). Please research more to bring out materials that states or show how budgeting and budgetary control can lead ..

  Do the calculations from requirements b and c

Do the calculations from Requirements b and c confirm your speculations in Requirement a?

  Prepare a forecast of the cumulative dollar impact

Calculate the material handling rate that would have been used by Eloise Smith's predecessor at East Coast Marine and calculate the revised material handling costs to be allocated on a per purchase order basis.

  First-stage allocation to the assembly activity cost pool

The costs in the Other activity cost pool are not assigned to products and How much overhead cost would be assigned to Product F76D using the activity-based costing system?

  Cost pop''s to produce and sell one more hamburger

What does it cost Pop's to produce and sell one more hamburger? Attached is the answer you gave me on the costs breakdown

  Trumbull value of debt and yield

Gomez computer systems has an EBIT of $200,000, a growth rate of 6%, and its tax rate is 40%. In order to support growth, Gomez must reinvest 20% of its EBIT in net operating assets. Gomez has $300,000 in 8% debt outstanding, and a similar company..

  Discuss the qualitative factors that the company will need

discuss the qualitative factors that company will need to take into consideration before accepting special order of supplying 100 thousand units to customer.

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