Act502 - prepare a flexible budget report for the year and


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

Solution Preview :

Prepared by a verified Expert
Managerial Accounting: Act502 - prepare a flexible budget report for the year and
Reference No:- TGS02445627

Now Priced at $35 (50% Discount)

Recommended (95%)

Rated (4.7/5)