Phillips Paints manufactures three types of paint in a joint process: rubberized paint, rust- proofing paint, and aluminum paint. In a standard batch of 500,000 gallons of raw material, the outputs are 240,000 gallons of rubberized paint, 80,000 gallons of rust-proofing paint, and 180,000 gallons of aluminum paint. The production cost of a batch is $2,700,000. The sales prices per gallon are $15, $18, and $20 for rubberized, rust-proofing, and aluminum paint, respectively.

Required

Construct a spreadsheet to allocate joint costs to the three products using the number of gallons as the allocation base.

Include formulas in your spreadsheet to calculate the gross margin for each paint.

Related Questions in Managerial Accounting - Others

to launch a new product. The segment margin of the new product would be $70,000 per year. (a) What will be the total relevant cost of 14,400 units, if they are manufactured internally? (Omit the "$" sign in your response.) Total relevant cost

Answer Preview :

Troy Engines, Ltd. Requirement 1: (a) What will be the total relevant cost of 14,400 units, if they are manufactured internally? (Omit the "$" sign in your response.) Total relevant cost...

Refer to Exercise 7-8. Required 1. Calculate the allocation ratios to be used under the reciprocal method for S1 and S2. Carry your calculations out to four digits. (S1 will have three allocation ratios—one each for S2, Cutting, and Sewing. S2 will have three allocation ratios

submission) The Font size must be in 11 points, should be in the style of Times New Roman, 1.5 line spacing and all pages numbered . For each question show full workings justifying your answer. Students submitting answers to question 5 (b) a review article of their choice should submit their review...

Weighted Average Method, Physical Flow, Equivalent Units, Unit Costs , Cost Assignment Mimasca Inc. manufactures various holiday masks. Each mask is shaped from a piece of rubber in the molding department. The masks are then transferred to the finishing department, where they are painted and have

Answer one paragraph only for each question and all the answers in one word file and make sure no plagiarism1- Are than any other reasons other than cost as to why an organization would choose to outsource cost? 2-Do you think that outsourcing is ne
Posted
3 days ago

Some companies have created controversy over the decision to outsource major activities to companies based in other countries. The decision to outsource should begin with an analysis of the relevant costs.What is your opinion of outsourcing?Should o
Posted
5 days ago

Harrison Company makes two products and uses a conventional costing system in which a single plantwide, predetermined overhead rate is computed based on direct labour-hours. These products are customized to some degree for specific customers. Data f
Posted
6 days ago

Harrison Company makes two products and uses a conventional costing system in which a single plantwide, predetermined overhead rate is computed based on direct labour-hours. These products are customized to some degree for specific customers. Data f
Posted
6 days ago

Financial Statement Analysis ProjectThe financial statement analysis project is due Thursday, November 15th by midnight via Canvas email. It will not be accepted late for any reason but you can submit it early.Project InstructionsStudents should rea
Posted
6 days ago

Some companies have created controversy over the decision to outsource major activities to companies based in other countries. The decision to outsource should begin with an analysis of the relevant costs. · oWhat is your opinion of outsourcing? oSh
Posted
8 days ago

An unfavorable variable overhead spending variance may be caused bya. the payment of lower prices for variable overhead items used. b. the use of excessive quantities of the variable overhead allocation base. c. the use of excessive quantities of va
Posted
8 days ago

Morton Ltd had on issue $5,000,000 10% unsecurednotes at 30 June 2011. Following agood year, the company had surplus cash at its disposal. On 31 March 2012 it took the opportunity tore-purchase $3,000,000 of its unsecured notes at a price of $103 fo
Posted
13 days ago

Financial Statement Analysis ProjectThe financial statement analysis project is due Thursday, November 15th by midnight via Canvas email. It will not be accepted late for any reason but you can submit it early.Project InstructionsStudents should rea
Posted
15 days ago