You work in the corporate controller's office for Sharpe Glassworks, Inc. Sharpe manufactures 12 ounce beer...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 own. The bottles are sold to brewers by the case, at prices generally ranging between $25 and $28 per case, and there are 100 bottles to a case. STANDARD COSTING Direct materials Sand makes up about 85% of the weight of the finished product, and is the only material treated as a direct material. All other materials are treated as indirect, and thus part of manufacturing overhead. There are 19,300 grams of sand in one finished goods unit (case), but not all sand purchased makes it into the finished product. Waste and scrap in the normal manufacturing process results in approximately 5% of the sand purchased being lost. Sand is purchased by the metric ton (one million grams). The cost from Sharpe's main supplier is $9.85 per metric ton, shipped locally at a cost to Sharpe of $18.05 per metric ton. Direct labor Each case is expected to require 0.50 direct labor hours to complete. This amount comes from process analysis at Sharpe, and does not include setup and down time, which are expected to average 0.19 hours per case. Sharpe pays its direct laborers an hourly wage of $19.00. Payroll taxes and benefits average $5.45 per direct labor hour. Manufacturing overhead Sharpe uses a traditional costing system and allocates overhead on the basis of standard direct labor hours. There are $394,000 of overhead costs expected in 2022, and 2022's unit sales are budgeted at 55,000 cases. JANUARY 2022 RESULTS In January, 2022, sales were $109,900 on 4,300 units sold. 96 metric tons of sand were purchased and used at a total cost, including shipping, of $2,400. Actual direct labor costs were $73,900, and actual direct labor hours were 2,950. Actual overhead costs were $33,100. 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.] Sharpe Glassworks, Inc. Standard Cost Worksheet Standard Standard Manufacturing Cost Element Standard Quantity Price Cost %3D Direct materials metric tons Direct labor hours Manufacturing overhead hours Total Supporting calculations: Sharpe Glassworks, Inc. Income Statement *FOR INTERNAL USE ONLY* Sales revenue Cost of goods sold (at standard) Standard gross profit Variances Materials price Materials quantity Labor price Labor quantity Manufacturing overhead Total variance Gross profit (actual) Supporting calculations: %24 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 own. The bottles are sold to brewers by the case, at prices generally ranging between $25 and $28 per case, and there are 100 bottles to a case. STANDARD COSTING Direct materials Sand makes up about 85% of the weight of the finished product, and is the only material treated as a direct material. All other materials are treated as indirect, and thus part of manufacturing overhead. There are 19,300 grams of sand in one finished goods unit (case), but not all sand purchased makes it into the finished product. Waste and scrap in the normal manufacturing process results in approximately 5% of the sand purchased being lost. Sand is purchased by the metric ton (one million grams). The cost from Sharpe's main supplier is $9.85 per metric ton, shipped locally at a cost to Sharpe of $18.05 per metric ton. Direct labor Each case is expected to require 0.50 direct labor hours to complete. This amount comes from process analysis at Sharpe, and does not include setup and down time, which are expected to average 0.19 hours per case. Sharpe pays its direct laborers an hourly wage of $19.00. Payroll taxes and benefits average $5.45 per direct labor hour. Manufacturing overhead Sharpe uses a traditional costing system and allocates overhead on the basis of standard direct labor hours. There are $394,000 of overhead costs expected in 2022, and 2022's unit sales are budgeted at 55,000 cases. JANUARY 2022 RESULTS In January, 2022, sales were $109,900 on 4,300 units sold. 96 metric tons of sand were purchased and used at a total cost, including shipping, of $2,400. Actual direct labor costs were $73,900, and actual direct labor hours were 2,950. Actual overhead costs were $33,100. 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.] Sharpe Glassworks, Inc. Standard Cost Worksheet Standard Standard Manufacturing Cost Element Standard Quantity Price Cost %3D Direct materials metric tons Direct labor hours Manufacturing overhead hours Total Supporting calculations: Sharpe Glassworks, Inc. Income Statement *FOR INTERNAL USE ONLY* Sales revenue Cost of goods sold (at standard) Standard gross profit Variances Materials price Materials quantity Labor price Labor quantity Manufacturing overhead Total variance Gross profit (actual) Supporting calculations: %24
Expert Answer:
Answer rating: 100% (QA)
Answer Solution Standard cost of direct material i Standard quantity of material required ... View the full answer
Related Book For
Basic Business Statistics Concepts and Applications
ISBN: 978-0132168380
12th edition
Authors: Mark L. Berenson, David M. Levine, Timothy C. Krehbiel
Posted Date:
Students also viewed these business communication questions
-
You work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per-store daily customer count has been steady, at 900, for some time (i.e., the...
-
You work in the human resources department of your company helping new employees fill out the necessary paperwork to get their first paycheck. There are a number of decisions that employees must make...
-
You work in the Office of the Comptroller General. The Director to whom you report has recently returned from a conference on public sector financial reporting. Among the topics discussed was a new...
-
Why do the requirements drift once a project is under way?
-
Find the standard normal area for each of the following, showing your reasoning clearly and indicating which table you used. a. P (1.22 < Z < 2.15) b. P (2.00 < Z < 3.00) c. P (2.00 < Z 2.00) d. P (Z...
-
The energy flux associated with solar radiation incident on the outer surface of the earth's atmosphere has been accurately measured and is known to be 1353 W/m 2 . The diameters of the sun and earth...
-
Journalize the following adjusting entries at December 31: 1. Services provided but not recorded, $1,500. 2. Salaries earned by employees but not recorded, $2,300. 3. Accrued interest on a note...
-
Use the information for Navajo Corporation from BE10-8. Prepare the journal entry to record the exchange, assuming the exchange lacks commercial substance.
-
Suppose that you have taken a short position on a call option. The strike price if $55, and the option premium / price is $5.When the option expires, the value of the underlying asset is $54. What is...
-
It is late 2019, and you are a successful executive working in New York for a large company. Tomorrow morning you will have the opportunity to negotiate receiving a $100,000 bonus at the end of the...
-
Wildhorse Manufacturing incurs $82,900 of direct labour costs. Supporting records show that the assembly department used $47,500 of the direct labour and the finishing department used the remainder....
-
Explain and contrast unique ( individual , unsystematic ) risk of a firm and market ( systematic ) risk. Explain how unique risk and market risk can be measured.
-
Wendy runs a factory that makes stereo tuners. Each S100 takes 6 ounces of plastic and 4 ounces of metal. Each FS20 requires 3 ounces of plastic and 6 ounces of metal. The factory has 252 ounces of...
-
Explain how each of the five major areas of management interact and intersect, when providing UBUNTU operating system services. Discuss how design assumptions may have influenced the development of...
-
Marianne's duplex sold at a foreclosure auction for $280,000. At the time of foreclosure, she had not made any payments to the bank for 11 months ($2,400 each). The outstanding balance of her...
-
INCOME STATEMENT Net Sales $31,000,000 Cost of Goods Sold $10,230,000 Gross Profit $20,770,000 Depreciation Expense $2,200,000 S&A Expenses $1,088,000 Operating Income (EBIT) $17,482,000 Interest...
-
If someone's Z-score for a variable was 0.67. Their score is a significant extreme score. Their score is not significant. O Their score is slightly above average. O Their score is an outlier.
-
The file ChocolateChip contains the cost (in cents) per 1-ounce serving for a sample of 13 chocolate chip cookies. The data are as follows: a. Compute the mean, median, and mode. b. Compute the...
-
A sample of 44 graduate students answered the following survey: 1. What is your gender? Female ______ Male ______ 2. What is your age (as of last birthday)? ______ 3. What is your current major area...
-
Determine the critical value of x2 with 1 degree of freedom in each of the following circumstances: a. = 0.05 b. = 0.005 c. = 0.10
-
The following data come from the inventory records of (. Dodge Company: Based on these facts, the gross profit for Dodge Company is a. \(\$ 150,000\). b. \(\$ 220,000\) c. \(\$ 190,000\). d. some...
-
A sample of students is enrolled in a speed-reading class. Each takes a reading test before and again after the class. The two samples of scores are compared to determine how large an improvement in...
-
A sample of students is enrolled in an online statistics class, and another sample is enrolled in a traditional statistics class. At the end of the semester, the students are given a test. The scores...
Study smarter with the SolutionInn App