Question: Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change

Please show formulas using excel

Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion.

Work in process, April 110,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000

Conversion: 20% complete, cost of ................................................................................................................. 4,500

Balance in work in process, April 1 ..................................................................................................................$ 26,500

Units started during April ......................................................................................................................................100,000

Units completed during April and transferred out to finished-goods inventory .................................................80,000

Work in process, April 30:

Direct material: 100% complete

Conversion: 33 1 3 % complete

Costs incurred during April:

Direct material ..................................................................................................................................................$198,000

Conversion costs: Direct labor ...................................................................................................................................................$ 52,800

Applied manufacturing overhead ................................................................................................................ 105,600

Total conversion costs .................................................................................................................................$158,400

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Ronald Moore can manufacture recyclable soft drink cans. A unit of production is a case of 12 dozen cans. The following standards have been set by the production-engineering staff and the controller....

Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 70 percent collected in the month of sale. 15 percent collected in the first month...

Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirements. Show how the soluvtion will change if the following information changes: actual output was 9100 cases, and the...

Tutor, again I'm needing your help! Im needing it before Wed. ACC650Module5-RoybalR is the blank doc, Thank you so so much! FreshPak Corporation manufactures two types of cardboard boxes used in...

5-53 Drirs Refer to the original data given in the preceding problem for Rapid City Technology, Inc. Required: I. Calculate the unit cost of a production order for 200 specially coated containers...

Management Accounting lesson. Answer all plis do not use handwritting. Thankyouu He ik, Moton, David PumManagerial Accounting pdf-Adbeder Lt View Window Help Open (5154) Bookmarks CO Exercises G R...

can someone answer exercise 17.18 and 17.19? Exercise 17-18 Direct Method of Service Department Cost Allocation; College (LO 17-1) Bay State Community College enrolls students in two departments,...

i need solution for given attachment in excel with relevant formulas Revised Problem 9-43 Freshpak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit and...

Please complete the attached spreadsheet. There are 2 tabs that need to be completed 9-43 and 11-26. The blue boxes on the spreadsheets are the only items that needs to be answered. WHB ACC 650...

Juggling Act a juggler performs in a room whose ceiling is 3.0 m above the level of his hands. He throws a ball upward so that it just reaches the ceiling. (a) What is the initial velocity of the...

The Mr. Fizz Beverage Company bottles soft drinks into aluminum cans. The manufacturing process consists of three activities: 1. Mixing: water, sugar, and beverage concentrate are mixed. 2. Filling:...

rade payables are generally shown on a balance sheet as: Group of answer choices noncurrent liabilities current liabilities other liabilities part of owners' equity

Which of the following is true of Generation Z ? ( Read through all answers. ) All of the answers listed are true Prefer popular mass produced products that look just like what their friends have...

1. Judith Sills, clinical psychologist who writes a column for Psychology Today, says your brand is the professional identity you create in the minds of others. Would you take the time to create your...

3. Do you agree that pride building can be localized throughout the organization?

2. Many of the Top Small Workplace managers report that they invest more in training, recognition awards, and incentive programs than competing firms. They say these investments result in reduced...