Please, use Excel and show the formulas The Oliver Cards Company is a card manufacturer. All...

Please, use Excel and show the formulas

The Oliver Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process.

For August, the beginning work in process inventory for the Finishing Department was 9,800 units that averaged 65 percent complete for conversion costs. Materials were done. Ending work in process inventory was 18,600 units averaged 85 percent complete for conversion costs. Materials were done. Production data shows 188,400 units were started during the period. Beginning work in process inventory costs totaled $11,282 including $7,300 for conversion costs. For the month of August, additional costs totaling $75,000 for direct materials and $111,034 for conversion costs were added in the finishing department during the period. Use weighted average method.
1. Prepare in good form a process report.
2. Prepare the journal entry to move costs to finished goods.
3. Prepare any journal entry, if required, for costs remaining in WIP.

Expert Solution

ekkarill92 answered 1 year ago

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

Please use EXCEL to answer and show all formulas. I can't understand the answer if I...

Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just completed, Grips earned $4.25 per share and paid cash dividends of $2.55 per share (D0=$2.55). Grips' earnings and dividends are expected to grow at 25% per year for the next 3 years, after which they are...

Please use excel and show all work and formulas. (I will give your work a like...

Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...

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 1—10,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...

The Jackpots Dreams Cards Company is a card manufacturer. All direct materials are added at the...

The Jackpots Dreams Cards Company is a card manufacturer. All direct materials are added at the beginning of production in the Finishing Department. Conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was 18,500 units averaging 45 percent complete. Production data shows 188,400 units were...

Solve in excel please. Show formulas A manufacturer of raisin bran cereal claims that each box...

Solve in excel please. Show formulas A manufacturer of raisin bran cereal claims that each box of cereal has more than 200 grams of raisins. The firm selects a random sample of 64 boxes and records the amount of raisin (in grams) in each box. a. Identify the null and the alternate hypotheses for this study. b. Is there statistical support for the manufacturer’s claim at a significance level of 5%? What about at 1%? Test your hypothesis using both,...

a) The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs...

a) The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was 18,500 units averaging 45 percent complete. Production data shows 188,400 units were started during the period. Beginning work in process inventory...

USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected...

USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected cash flows: • NOI is expected to be $130,000 in year 1 with 5 percent annual increases. • The purchase price of the property is $720,000. • 100 percent equity financing is used to purchase the property. • The property is sold at the end of year 4 for $860,000 with selling costs of 4 percent. • The required unlevered rate of return is...

*PLEASE USE EXCEL AND SHOW FORMULAS** Barry and Samantha are starting to take their retirement planning...

***PLEASE USE EXCEL AND SHOW FORMULAS**** Barry and Samantha are starting to take their retirement planning seriously. They are both 46 and plan to retire in 20 years at the age of 66. They expect to live 20 years in retirement (a life expectancy of 86). Between their 401k and IRA accounts they currently have $84,295 in retirement savings. They currently have a combined income of $80,000 per year and expect to be able to live comfortably in retirement with...

Question