Question

In: Accounting

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

Please, use Excel and show the formulas

  1. 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.

Solutions

Expert Solution


Related Solutions

***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...
Please use excel and show the excel formulas in detail. Alice wants to deposit $35,000 now...
Please use excel and show the excel formulas in detail. Alice wants to deposit $35,000 now $45,000 at the end of 6 years at a bank that pays 10% interest compounded semiannually. She wants to withdraw an amount every year for the first 6 years and to withdraw exactly $1000 more for the following four years. What is the maximum amount she could withdraw in year 1?
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,...
SHOW ALL THE FORMULAS IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS. Please! Question Set 2....
SHOW ALL THE FORMULAS IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS. Please! Question Set 2. A manufacturing operation must periodically purchase bulk quantities of bolts. The bolts are purchased in boxes of 500 and are consumed at a constant rate. The operation expects to purchase 28,000 boxes over the coming year. Each box costs $140, the annual holding cost per box is $22, and the cost of placing an order is $170 (regardless of the quantity ordered). For the...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT