Determine the unit costs for each of the five products

Assignment Help Other Subject
Reference no: EM131451615

Shatin Dairy Farm

Shatin Dairy Farm is a small, family-owned business that started its operations in 1996 with the goal of using all natural processes to create high quality dairy products. The company produces several different products sold in health food markets and some of the larger supermarkets in the area as well as in the Shatin Country Store, a small retail store located next to the farm. Shatins' products are well-known for their quality and have gained a strong brand-loyalty throughout the region in which Shatin operates. A key competitive factor for Shatin is that is uses only glass bottles in the packaging of its products, which appeals to many of its targeted customers.

Shatin's sales have grown rapidly in recent years, but production is currently limited by the number and size of the facilities on site that can only accommodate 300 animals (of which 130 cows are part of the milking herd). As a result, Shatin is considering expanding its operations to allow it to meet the increasing demand for its products. In order to expand, Shatin would have to buy additional land, build more barns and enlarge the milking facility. Shatin's manager, Laura Ashley, is concerned about the potentially large financial outlays that Shatin would incur with expansion and she feels that she should examine whether or not current operations are efficient and cost effective before expanding.

Laura is also considering the possibility of packaging the farm's product in plastic and paper containers instead of glass bottles.   She expects that this would attract new customers, and in addition, it would reduce costs significantly.  The direct cost of packaging the product (now $.75 per bottle) would be about one-third the current cost, and the cost of the bottling equipment for filling the plastic or paper containers would fall to one-half the cost of the current equipment within 6 months time.   All other costs would remain the same. Also, Laura thinks the sales of the farm's products would grow even faster with the broadened product line - the brand reputation of the farm's products could be leveraged to bring in new customers and the use of plastic or paper containers would enable the farm to attract new supermarkets and other retailers that do not presently handle bottles. Laura thinks that the supermarket customers would be willing to pay at least $.40 per quart more for Shatin products relative to other store brands.

Laura subscribes to the relevant trade journals in dairy farming, and has excerpted the following information from a recent issue of one of her journals.   It shows the buying criteria of a sample of supermarket customers who were purchasing milk in plastic and paper containers (1 = most important, and 5 = least important).  The current supermarket prices for these products in Shatin's area are $1.25 per quart for each product except eggnog which sells for $1.80. Supermarkets mark up the price of milk by about 40% from dairy cost, so the price received by the dairy is somewhat less.

Attribute Importance Ranking, by Product

Buying Criteria

Whole Milk

Low-Fat Milk

Skim Milk

Chocolate Milk

Eggnog

Freshness

3

3

2

4

4

Packaging

4

5

4

5

3

Taste

2

2

3

1

1

Color and Texture

5

4

5

3

2

Price

1

1

1

2

5

Background about Shatin's Operations -

The main processes involved in milk production are as follows:

1. Milking: An employee begins by sanitizing the cows.  Once this is done, the employee attaches the cows to an electronic milking machine. The machine automatically provides information on the number of gallons produced by each cow and pumps the milk into a holding tank before the next process begins. This is a very time- consuming and labor-intensive process because the milking pen currently accommodates 12 cows at a time. The rest of the cows are kept in the milking barn until it is their turn to be milked. Milking the entire milking herd takes between three and four hours per day.

2. Separating: In this process, a machine sorts the cream from the milk.  The cream is then stored in a vat until it is made into butter or is added back to the milk to create either, low-fat, chocolate, or whole milk or eggnog.

3. Pasteurizing: Pasteurizing is the process by which any bacteria in the milk are killed.  Milk runs through hot plates, bringing it to a temperature of 175 F degrees. Then, the milk is run through cold plates to bring it to the optimal storage temperature of 38 F degrees.

4. Homogenizing: After pasteurization, the milk is homogenized by breaking up fat molecules in the milk by running the milk through a high pressure system. This process is done for cosmetic purposes to create a rich, creamy finished product. This step is the last step in the production process for whole milk, skim milk, and low- fat milk.  These three types of milk are then stored in separate holding tanks until the bottling process begins.

5. Mixing:  This process is only completed for chocolate milk and eggnog.  In this process, sugar and other ingredients are added and mixed into the milk to create the finished product.

6. Bottling: Bottling is a very costly process for Shatin. Shatin uses glass bottles to package its milk products, which requires more filling time than paper or plastic containers. Before the bottles can be filled, employees must sterilize and sanitize the glass bottles. The clean bottles are then placed on a conveyer belt to be filled. The filling of the bottles is completed by a machine that fills each bottle and also places plastic caps on the bottles. An employee removes the filled bottles from the conveyor belt and places them into crates.

7. Warehousing: When the crates are filled, an employee moves them to the refrigeration room in the warehouse. They are stored in the room until they are shipped. In addition to the refrigeration room, the warehouse also holds new and returned glass bottles as well as ingredients like sugar that are added to the milk in the mixing process.

The products produced by Shatin and current prices received by Shatin are as follows:

  • Whole Milk, $1.90 per quart
  • Low-Fat Milk, $1.90
  • Skim Milk, $1.90
  • Chocolate Milk, $1.90
  • Eggnog, $2.25

Bottles are produced in one size - quarts. Selected data for the most recent year are as follows:

Whole Milk

Low-Fat Milk

Skim Milk

Chocolate Milk

Eggnog


145

500

333

455

525

Number of Invoices

292,000

730,000

511,000

219,000

187,000

Number of Bottles Produced

373

933

653

290

270

Number of Purchase Orders

48

66

85

71

43

Number of Customers

166

304

236

144

135

Labor Hours, Warehousing

2

2

3

3

4

Number of Quality Checks per Order

87

422

345

132

112

Machine Hours, Separating

0

0

0

385

355

Machine Hours, Mixing

199

433

312

187

177

Machine Hours, Bottling

98

312

177

88

122

Labor Hours, Clean and Repair

Shatin's Accounting System

Shatin has a conventional accounting system which keeps track of overhead costs in four categories: bottling equipment, facilities, processing, and general and administrative. There are sub-accounts in each of these accounts except for bottling equipment.  The accounts, sub-accounts and costs for the most recent operating year are shown in Table 1. These costs are often called resource costs, and are labeled as such in the OROS software system. Shatin grows on site most of the feed needed at the dairy farm. The cost of producing the feed and some additional feed purchased during the year is included under labor and materials for other processing costs.

Table 1: Overhead (Resource) Costs for Shatin Dairy Farm

ACCOUNTS

SUB ACCOUNTS

ACTUAL COSTS

Bottling Equipment


$1,528,620

Other Facilities Costs

Utilities

72,395


Depreciation

22,976


Property Tax

10,014

Total Other Facilities Cost


$105,385

Other Processing Costs

Labor and materials

428,800


Supplies

4,278


Equipment repairs and maintenance

21,565


Depreciation

13,688

Total Other Processing Cost

$468,331

General and Administrative

Administration

105,522


Interest Expense

23,471

Total General and Administrative

$ 128,993

Total


$2,231,329




In addition to the overhead costs, Shatin has direct costs for bottles and other materials. These materials are purchased from a variety of suppliers. Each glass bottle costs Shatin $.75, including both purchase and recycling cost. Other ingredients include cocoa, sugar, and spices. Cocoa, used in the production of chocolate milk, costs $.05 per bottle. Sugar, used in both chocolate milk and eggnog, costs $.05 per bottle.  Spices, used to make eggnog, cost $.08 per bottle. In total, 65,700 ounces of sugar and cocoa were used in the production of chocolate milk, and 76,650 ounces of sugar and spice were used in the production of eggnog.

Laura has heard from a local vendor that information from an activity-based costing would be helpful to Laura in improving Shatin's operations. With some guidance from a cost consultant recommended by the vendor, the following production activities were identified

  • Milking
  • Separating, pasteurizing, and homogenizing
  • Mixing
  • Bottling
  • Warehousing
  • General and Administrative (G&A)
  • Receiving and Inspecting
  • Cleaning and Repairs

Overhead (Resource)-consumption Cost Drivers -

Laura has further analyzed the cost structure, to determine how the overhead (resource) costs could be allocated to the eight activities identified above. On the advice of the cost consultant, she determined that all costs in the general and administrative account could be allocated to the general and administrative activity. Moreover, most (90%) of the costs in the bottling machine account could be allocated to the bottling activity, and the remainder to the receiving and inspecting activity. Determining how the other processing costs could be related to the activities is not as simple, but after some careful study the following estimates were made for the other processing costs account:


% Usage of Other

Activities Using Other Processing Costs

Processing Costs

Milking

30%

Separating/Pasteurizing/Homogenizing

15%

Mixing

15%

Bottling

25%

Warehousing

10%

G&A

0%

Receiving and Inspecting Ingredients

0%

Cleaning and Repairs

5%

Total

100%

The other facilities cost account includes the costs of maintaining the warehouse and milking barn, and is allocated to the activities on the basis of square feet.      Square feet are therefore the resource-consumption cost driver for the other facilities cost account, which is one of Shatin's overhead (resource) accounts.

Activities

Square Ft

Milking

10,000

Separating/Pasteurizing/Homogenizing

2,000

Mixing

1,000

Bottling

1,500

Warehousing

12,500

G&A

2,000

Cleaning and Repairs

1,000

Total

30,000

Activity-consumption Cost Drivers

After some additional study, it was decided that the best way to allocate the costs of each activity to the products was to use the following activity-consumption drivers:

Activities

Activity-consumption Cost Driver

Milking

Number of bottles produced

Separating/Pasteurizing/Homogenizing

Machine Hours, Separating

Mixing

Machine Hours, Mixing

Bottling

Machine Hours, Bottling

Warehousing

Labor Hours, Warehousing

G&A

Number of Invoices

Receiving and Inspecting

Ounces

Cleaning and Repairs

Labor Hours, Clean and Repair

Required -

1. Assess the competitive environment of Shatin Dairy Farm and determine what you think is or should be Shatin's competitive strategy, and explain why.

2. Determine the unit costs for each of the five products given the available information.

3. How could you improve on these calculations?

I need this done in British english.

Reference no: EM131451615

Questions Cloud

Considering buying machine-what is the nal of the lease : Super Sonics Entertainment is considering buying a machine that costs $610,000. What is the NAL of the lease?
Discuss the canadian union of postal workers : Do you think there might be any positive and significant relationship between the possession of certain personal values and successful career progression.
How many rupees will you receive in the conversion : how many rupees will you receive in the conversion?
What is the nominal annual interest rate : An engineering firm has to borrow funds to pay your 16 weeks co-op salary for the summer. what is the nominal annual interest rate?
Determine the unit costs for each of the five products : Shatin Dairy Farm - Determine the unit costs for each of the five products given the available information. How could you improve on these calculations
Do you think this implies about employee job satisfaction : When employees are asked whether they would again choose the same work or whether they would want their children to follow in their footsteps.
What is the slope of the security market line : A stock has an expected return of 11.3 percent and a beta of 1.08. The risk-free rate is 4.7 percent. What is the slope of the security market line?
How do you calculate the cost of capital : You would like to estimate the weighted average cost of capital for a new airline business. how do you calculate the cost of capital?
Describe the strategic role of organizational behavior : Describe the strategic role and purpose of organizational behavior for the company selected. Identify the organizational factors of organizational behavior.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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