Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sweetooth manufactures cakes in two departments, Mixing and Baking, using a process cost system. Data for each department for 20X3 are as follows: Mixing Baking

Sweetooth manufactures cakes in two departments, Mixing and Baking, using a process cost system. Data for each department for 20X3 are as follows:

Mixing Baking

Units: Work-in-process 1/1/X3 3,000 6,000

Started in process 49,000 ?

Completed and transferred 45,000 40,000

Work-in-process 12/31/X3 5,000 10,000

Costs: Work-in-process 1/1/X3

Transferred-in $ n/a $ 9,195

Materials 11,710 -0-

Conversion 2,926 2,524

Added to department

Transferred-in n/a ?

Materials 29,890 70,000

Conversion 45,374 75,190

Other: Materials added (% conversion) 0% 75%

Conversion complete

Beginning work-in-process 2/3 25%

Ending work-in-process 50% 60%

Inspection (% conversion) 100% 100%

Normal spoilage (% of units started) 3% 2%

The ingredients (flour, mild, eggs, etc.) are added at the beginning of the production process in the Mixing Department (i.e., 0% conversion). The cakes are baked in the Baking Department, after which the icing is applied (i.e., at 75% conversion).

Requirements: Use Microsoft Excel to prepare a cost of production report template for each department to be used for any data for any accounting period:

Enter the data above at the top of a spreadsheet exactly as it appears.

Prepare a cost of production report for each department.

Use the format presented in the snapshot of the solution. You will need to modify the format to account for potential normal and abnormal spoilage.

Use IF statements to make it possible to present the information under weighted average or FIFO for both departments.

Report your answers using the weighted average method for the Mixing Department and the FIFO method for the Baking Department.

The reports and journal entries should change automatically with changes in the data.

Enter all data into the reports with cell references to the data above (i.e., do not type the information directly into the report cells).

IF statements will be required (use the Excel Help feature for instructions).

The spreadsheet should create journal entries to transfer costs from WIP-Mixing to WIP-Baking and from WIP-Baking to finished goods (journal entries to record direct materials, direct labor and the overhead are not required). Be sure to include any entries to record abnormal spoilage costs.

Display cost per equivalent unit amounts with five decimals.

Display allocated costs and journal entry amounts with two decimals.

(PLEASE POST EXCEL SHEET DISPLAYING FUNCTIONS.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Glomont Auditing And Attestation AICPA Released Questions CPA Exam Review 2022

Authors: Glomont, American Institute Of Certified Public Accountants, AICPA

1st Edition

B0BF31GQMC, 979-8353524045

More Books

Students also viewed these Accounting questions

Question

1. Discuss the four components of language.

Answered: 1 week ago

Question

a. How many different groups were represented?

Answered: 1 week ago