Question

In: Accounting

Estimating production costs The Fancy Umbrella Company makes beach umbrellas. The production process requires 3 square...

Estimating production costs

The Fancy Umbrella Company makes beach umbrellas. The production process requires 3 square meters of plastic sheeting and a metal pole. The plastic sheeting costs $0.50 per square meter and each metal pole costs $1.00. At the beginning of the month, the company has 5,000 square meters of plastic and 1,000 poles in raw material inventory. The preferred raw material amount at the end of the month is 3,000 square meters of plastic sheeting and 600 poles. The company has 300 finished umbrellas in inventory at the beginning of the month and plans to have 200 finished umbrellas at the end of the month. Sales in the coming month are expected to be 5,000 umbrellas.

Required

a. How many umbrellas must the company produce to meet demand and have sufficient ending inventory?

b. What is the cost of materials that must be purchased?

Solutions

Expert Solution

a. The total number of umbrellas that the company would be required to produced would be :
  
Total Number of umbrellas to be produced = Umbrella required in the month - Umbrellas in inventory
= (Expected Sales + Closing Inventory) - Opening Inventory
= (5000+200) - 300

= 5200 - 300 = 4900 umbrellas are to be produced (Answer)

b. Cost of Plastic Materials to be purchased

Quantity of Plastic Required to be purchased = Plastic sheet required to produce 4900 umbrellas + Plastic sheet preferred in stock at the end of the month - Opening stock of plastic sheets

= 4900*3 sq meters + 3000 sq meters - 5000 sq meters

= 14700+3000-5000

= 12700 sq meters of plastic sheets is required to be bought

Cost of purchasing 12700 sq meters of plastic sheets = 12700 * $0.50

= $6350 (A)

Cost of Metal Poles to be purchased

Quantity of Metal Poles to be purchased = Metal poles required to produce 4900 umbrellas + Metal poles preferred in stock at the end of the month - Opening stock of metal poles

= 4900*1 pole + 600 poles - 1000 poles

= 4900+600-1000

= 4500 metal poles are required to be purchased.

Cost of purchasing 4500 metal poles = 4500 * $1.00

= $4500 (B)

Answer : Total cost of materials to be purchased = Cost of plastic sheets to be purchased (A) + Cost of metal poles to be purchased (B)

= 6350+4500

= $10,850


Related Solutions

Milo Company buys and sells beach umbrellas. The selling price of each beach umbrella is R150...
Milo Company buys and sells beach umbrellas. The selling price of each beach umbrella is R150 and it costs the company R70. The company is preparing budgets for the last quarter of the year and has assembled information to assist in the budget preparation. The marketing department has estimated sales as follows for the remainder of the year (in units): Month Expected demand September 4 000 October 3 000 November 7 000 December 5 000 The company sold 3 900...
Mohave Corp. makes several varieties of beach umbrellas and accessories. It has been approached by a...
Mohave Corp. makes several varieties of beach umbrellas and accessories. It has been approached by a company called Lost Mine Industries about producing a special order for a custom umbrella called the Ultimate Shade (US). The special-order umbrellas with the Lost Mine Company logo would be distributed to participants at an upcoming convention sponsored by Lost Mine. Lost Mine has offered to buy 3,500 of the US umbrellas at a price of $36 each. Mohave currently has the excess capacity...
The Company makes plain jobs and fancy jobs. Each plain job requires $100 of direct materials,...
The Company makes plain jobs and fancy jobs. Each plain job requires $100 of direct materials, $150 of direct labor, and 4 machine hours. Each fancy job requires $200 of direct materials, $300 of direct labor, and 7 machine hours. The company has $450,000 of total overhead for the year. Currently, the company charges all of the overhead to jobs based on machine hours. During the year, there are 2,000 plain jobs and 1,000 fancy jobs. Using this simplified cost...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter an...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 21,000 7,500 8,000 31,000 72,ee8 41,000 October July August September November December The selling price of the beach umbrellas is $11 per unit b. All sales are on account. Based on past experience, sales are collected In the following pattern: 38%...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 33,000 October 23,000 August 76,000 November 9,500 September 45,000 December 10,000 The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 34,000 October 24,000 August 78,000 November 10,500 September 47,000 December 11,000 The selling price of the beach umbrellas is $11 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation:      a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): The selling price of the beach umbrellas is $14 per unit.      July 38,500   October 28,500   August 87,000   November 15,000   September 56,000   December 15,500    b. All sales are on account. Based on past experience,...
Paradise Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Paradise Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 41,500 October 31,500 August 93,000 November 18,000 September 62,000 December 18,500 The selling price of the beach umbrellas is $14 per unit. All sales are on account. Based on past experience, sales are collected in the...
Paradise Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Paradise Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 41,500 October 31,500 August 93,000 November 18,000 September 62,000 December 18,500 The selling price of the beach umbrellas is $14 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 36,000 October 26,000 August 82,000 November 12,500 September 51,000 December 13,000 The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT