Alcott Company makes and sells artistic frames for pictures of weddings, graduations, and other special events....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Alcott Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Ron Kerry, the controller, is responsible for preparing Alcott's master budget and has accumulated the following information for 2018 (Click the icon to view some of the financial information.) i (Click the icon to view additional information.) Read the requirements. Requirement 1. Prepare a production budget and a direct manufacturing labor cost budget for Alcott Company by month and for the first quarter of 2018. You may combine both budgets in one schedule. The direct manufacturing labor cost budget should include labor-hours and show the details for each labor cost category. Start the schedule by preparing the production budget and calculating the total hours of direct manufacturing labor time needed for the three months in the quarter, then calculate the values for the quarter. Finish by preparing the bottom portion of the schedule for the direct manufacturing labor by month, then quarter. (Enter the direct manufacturing labor-hours per unit to one decimal place, X.X. Do not round interim calculations, and then enter all amounts in the budget (other than the direct manufacturing labor-hours per unit] to the nearest whole number.) - X Alcott Company Budget for Production and Direct Manufacturing Labor For the Quarter Ended March 31, 2018 January Budgeted sales (units) Add target ending finished goods inventory (units) Total requirements (units) Deduct beginning finished goods inventory (units) Units to be produced Direct manufacturing labor-hours per unit Total hours of direct manufacturing labor time needed Data table Estimated sales in units Selling price Direct manufacturing labor-hours per unit Wage per direct manufacturing labor-hour S February 2018 January February March April 15,000 19,000 8,000 12,000 53.00 $ 51.00 $ 51.00 $ 51.00 S 2.0 2.0 1.5 1.5 10.00 $ 10.00 $ 10.00 $ 13.00 S S March May 12,000 51.00 1.5 13.00 More info In addition to wages, direct manufacturing labor-related costs include pension contributions of 50.60 per hour, worker's compensation insurance of $0.20 per hour, employee medical insurance of $0.40 per hour, and Social Security taxes. Assume that as of January 1, 2018, the Social Security tax rates are 7.5% for employers and 7.5% for employees. The cost of employee benefits paid by Alcott on its direct manufacturing employees is treated as a direct manufacturing labor cost. Alcott has a labor contract that calls for a wage increase to $13 per hour on April 1, 2018. New labor-saving machinery has been installed and will be fully operational by March 1, 2018. Alcott expects to have 23,000 frames on hand at December 31, 2017, and it has a policy of carrying an end-of-month inventory of 100% of the following month's sales plus 50% of the second following month's sales. Print Done Alcott Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Ron Kerry, the controller, is responsible for preparing Alcott's master budget and has accumulated the following information for 2018 (Click the icon to view some of the financial information.) i (Click the icon to view additional information.) Read the requirements. Requirement 1. Prepare a production budget and a direct manufacturing labor cost budget for Alcott Company by month and for the first quarter of 2018. You may combine both budgets in one schedule. The direct manufacturing labor cost budget should include labor-hours and show the details for each labor cost category. Start the schedule by preparing the production budget and calculating the total hours of direct manufacturing labor time needed for the three months in the quarter, then calculate the values for the quarter. Finish by preparing the bottom portion of the schedule for the direct manufacturing labor by month, then quarter. (Enter the direct manufacturing labor-hours per unit to one decimal place, X.X. Do not round interim calculations, and then enter all amounts in the budget (other than the direct manufacturing labor-hours per unit] to the nearest whole number.) - X Alcott Company Budget for Production and Direct Manufacturing Labor For the Quarter Ended March 31, 2018 January Budgeted sales (units) Add target ending finished goods inventory (units) Total requirements (units) Deduct beginning finished goods inventory (units) Units to be produced Direct manufacturing labor-hours per unit Total hours of direct manufacturing labor time needed Data table Estimated sales in units Selling price Direct manufacturing labor-hours per unit Wage per direct manufacturing labor-hour S February 2018 January February March April 15,000 19,000 8,000 12,000 53.00 $ 51.00 $ 51.00 $ 51.00 S 2.0 2.0 1.5 1.5 10.00 $ 10.00 $ 10.00 $ 13.00 S S March May 12,000 51.00 1.5 13.00 More info In addition to wages, direct manufacturing labor-related costs include pension contributions of 50.60 per hour, worker's compensation insurance of $0.20 per hour, employee medical insurance of $0.40 per hour, and Social Security taxes. Assume that as of January 1, 2018, the Social Security tax rates are 7.5% for employers and 7.5% for employees. The cost of employee benefits paid by Alcott on its direct manufacturing employees is treated as a direct manufacturing labor cost. Alcott has a labor contract that calls for a wage increase to $13 per hour on April 1, 2018. New labor-saving machinery has been installed and will be fully operational by March 1, 2018. Alcott expects to have 23,000 frames on hand at December 31, 2017, and it has a policy of carrying an end-of-month inventory of 100% of the following month's sales plus 50% of the second following month's sales. Print Done
Expert Answer:
Answer rating: 100% (QA)
Step 1 Calculate Units to be Produced January Estimated sales 15000 units Target ending inventory 19000 8000 05 13500 units Units to be produced 15000 ... View the full answer
Related Book For
Horngrens Cost Accounting A Managerial Emphasis
ISBN: 978-0134475585
16th edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these accounting questions
-
Do not use a calculator in this question. Explain the reasoning involved in arriving at the answers. (a) Find ord10 (3). (b) Use your answer to part (a) to find the remainder on dividing 34 by 10....
-
Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletters master budget...
-
DeWitt Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Ron Bahar, the controller, is responsible for preparing DeWitt's master budget and has...
-
A utilization greater than one suggests that the mean service time is higher than the mean inter-arrival time. True False QUESTION 3 It costs five times more money to retain a current customer than...
-
Explore the issues around Internet privacy and discuss the way that regulation is likely to develop.
-
Discuss the use of deterrence arguments for the death penalty. Also summarize opponents criticisms of these arguments.
-
Preparing a Statement of Retained Earnings Refer to the information for Sparrow Company above. Required: Prepare a statement of retained earnings for Sparrow for 2018 . \section*{Cornerstone Exercise...
-
Consider the blending system shown in Figure. A feedback control system is used to reduce the effect of disturbances in feed composition, x 1 , n the controlled variable, product composition, x....
-
Smart Edge Limited buys and sells smart devices and is a South African company with a February year - end. On 1 November 2 0 2 3 , Smart Edge Limited purchased trading stock on credit from a supplier...
-
Read the article Matter and thermal physics and answer the questions: 1. did anything happen when you squeezed the bottle the first time? 2. What happened when you squeezed the bottle after dropping...
-
K Evaluate the definite integral. 8 3 (3n-2-n) dn 3 8 -2 (3n- - n) dn = 3 (Type an integer or a simplified fraction.)
-
The following information was available for the year ended December 31, 2022: Net sales Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory...
-
On January 1 , 2 0 2 2 , Pharoah Country Club purchased a new riding mower for $ 2 0 , 0 0 0 . The mower is expected to have a 5 - year life with a $ 6 , 0 0 0 salvage value. What journal entry would...
-
1. In detail, discuss at least 10 important biases related to finance and provide examples of how individuals are impacted by these biases financially. Be sure to talk about the important points. 2....
-
The stock of Sony is forecasted to pay dividends in the next three years as follows: D 1 =$1.7, D 2 =$2.2, D 3 =$2.9. The company's stock price is estimated to be $50 at the end of three years. The...
-
Mr. Del Valle is 54 years old and plans to retire in 8 years. He wants to live at least 20 years after he retires. He has $125,000 in savings and expects to earn 7% annual interest. He expects to...
-
-36 Write P(x) in lowest terms. Select the correct choice below and, if necessary, fill in the answer box to complete your choice. OA. P(x)= (Simplify your answer.) B. P(x) is already in lowest...
-
You are standing on the top of a building and throw a ball vertically upward. After 2 seconds, the ball passes you on the way down, and 2 seconds after that, it hits the ground below. a. What is the...
-
lees Corp. is deciding whether to keep or drop a small segment of its business. Key information regarding the segment includes: Contribution margin : 35,000 Avoidable fixed costs: 30,000 Unavoidable...
-
Assume variable manufacturing overhead is allocated using machine-hours. Give three possible reasons for a favorable variable overhead efficiency variance?
-
Chocolat Inc. decides to examine the effect of using the dual-rate method for allocating truck costs to each roundtrip. At the start of 2017, the budgeted costs were: Variable cost per...
-
If equity investors contribute $1,000,000 and want a .30 return at time 4, how much do they require at time 4?
-
a. Assume the value of a firm's equity is $1,000 and $800 of .10 debt is substituted for equity. The corporate tax rate is .35. What is the new value of the equity? What total wealth do the...
-
Assume a $800 investment returns $1,000 at time 1 (a .25 return). What is the IRR on $100 of equity if $700 of .08 debt is used as well as equity?
Study smarter with the SolutionInn App