Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I just need help with the income statement part. I appreciate your help!! Sharpe Glassworks, Inc. Income Statement FOR INTERNAL USE ONLY* Sales revenue $

I just need help with the income statement part. I appreciate your help!!

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Sharpe Glassworks, Inc. Income Statement "FOR INTERNAL USE ONLY* Sales revenue $ 119,900.00 Cost of goods sold (at standard) Standard gross profit 119,900.00 Variances Materials price Materials quantity Labor price Labor quantity Manufacturing overhead Total variance Gross profit (actual) Supporting calculations:Sharpe Glassworks, Inc. Standard Cost Worksheet Standard Standard Manufacturing Cost Element Standard Quantity Price Cost Direct materials 0.0210 metric tons 18.25 0.3825 Direct labor 0.51 hours 20.85 10.6335 Manufacturing overhead 0.51 hours 16.50706794 8.4186 Total 19.4346 Supporting calculations: Direct materials =(19700/1000000)*(100/94) metric tons =18.25 =D16*G16 Direct labor =0.34+0.17 hours =16.6+4.25 =D18*G18 Manufacturing overhead =D18 hours =362000/(43000*D18) =D20*G20 Total SUM(116:120]B E You work in the corporate controller's office for Sharpe Glassworks, Inc. Sharpe manufactures 12 ounce beer bottles for smaller breweries who lack the scale or vertical integration to make their 9 own. The bottles are sold to brewers by the case, at prices generally ranging between $25 and $28 10 per case, and there are 100 bottles to a case. 11 12 STANDARD COSTING 13 Direct materials 14 Sand makes up about 85%% of the weight of the finished product, and is the only material 15 treated as a direct material. All other materials are treated as indirect, and thus part of 16 manufacturing overhead. There are 19,700 grams of sand in one finished goods unit (case), 17 but not all sand purchased makes it into the finished product. Waste and scrap in the normal 18 manufacturing process results in approximately 6%% of the sand purchased being lost. 19 20 Sand is purchased by the metric ton (one million grams). The cost from Sharpe's main 21 supplier is $9.75 per metric ton, shipped locally at a cost to Sharpe of $18.25 per metric ton. 22 23 Direct labor 24 Each case is expected to require 0.34 direct labor hours to complete. This amount comes 25 from process analysis at Sharpe, and does not include setup and down time, which are 26 expected to average 0.17 hours per case. 27 28 Sharpe pays its direct laborers an hourly wage of $16.60. Payroll taxes and benefits average 29 $4.25 per direct labor hour. 30 31 Manufacturing overhead 32 Sharpe uses a traditional costing system and allocates overhead on the basis of standard 33 direct labor hours. There are $362,000 of overhead costs expected in 2022, and 2022's unit 34 sales are budgeted at 43,000 cases. 35 36 JANUARY 2022 RESULTS 37 In January, 2022, sales were $119,900 on 4,540 units sold. 38 92 metric tons of sand were purchased and used at a total cost, including shipping, of $2,200. 39 Actual direct labor costs were $43,200, and actual direct labor hours were 2, 140. 40 Actual overhead costs were $28,600.INSTRUCTIONS 1. Complete the Standard Cost Worksheet in the "Standard Costs"tab. All items should be shown to at least two decimal places, except metric tons per case, which must be shown to at least four decimal places.* 2. Complete the Standard Cost Income Statement in the "January Review" tab. 3. Prepare, in a separate Word document, a brief memo describing which variances you, in a controlling function, are most curious about, and why. Who would you contact for explanations about those variances. Your solution should use formulas and cell references instead of keyed in values where possible. For instance, each tab has an area to show your work, and you should use formulas to work out standard quantities, price variances, etc., then cell references to pull those results into the required schedule. Besides reinforcing good practices, this will make your work easier and less subject to error. Load both completed files into Canvas by 8:00 PM on April 26. [* - Note on decimal places (and why so many of them are needed for standard quantities). If, for instance, your standard quantity was 28,700 grams of sand per unit of finished goods, then your standard quantity would be 28,700 grams divided by one million grams per metric ton, or 0.0287 metric tons.]

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

Step: 3

blur-text-image

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

Financial Accounting Fundamentals

Authors: John Wild

4th Edition

0078025591, 9780078025594

More Books

Students also viewed these Accounting questions

Question

13. Give four examples of psychological Maginot lines.

Answered: 1 week ago