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...
-
Find I o in the network in figure using Thevenin?s theorem. 32 kn +)6 V 1 kn 2 kn 2 kn 2 mA
-
Deduce the structure of each of the following compounds on the basis of their 1H NMR spectra and molecular formulas: (a) C8H10; 1.2 ppm (triplet, 3H) δ2.6 ppm (quartet, 2H)...
-
War by Parker is an eyewear company that sells prescription glasses, sunglasses, contact lenses, and related services. Founded in 2010 as an online retailer, the firm now sells online and through 223...
-
Assume that Job # 10 of Jellyfish Machine Shop generates normal scrap with a total sales value of $ 700 (it is assumed that the scrap returned to the storeroom is sold quickly). Prepare the journal...
-
A ( n ) _ _ _ _ _ _ _ _ _ _ contains a specific piece of information within a record. Field Entity Row Database
-
1. Sharps Sandwich Shop has two conflicting quality issues speed and freshness. The premade sandwich system enhances speed; however, it has the potential of affecting freshness. What type of system...
-
Your company has determined that the time is right to expand globally. As a corporate manager within the organization, you have been assigned to identify and select a team of five to ten members from...
-
How is the act of Projection at play in how the narrator uses the Old Man/how he perceives his Evil Eye to maintain the sense of self, the Persona , he is compulsively beholden to? Consider the...
-
Describe the strategic implications of self-driving cars or robotics on traditional companies.
-
How is HR Planning linked to a companys strategic goals? If a company is expecting 50% growth per year for 3 years, how can trend analysis be used to determine HR demand? Is ration analysis helpful...
-
A trader at a bank takes a call from a customer interested in buying a $50.00 straddle. The current stock price is $49.00, the interest rate is 6%, the implied volatility is 40%, and there are 90...
-
What is a virtual machine? 2. What is a Java Virtual Machine? 3. What is Java bytecode? 4. What is the relationship between Java Virtual Machines and Java bytecode? 5. If you were invited to a class...
-
Problem 1 Consider the following 2D function: f(x, x) = x + xx + 2x +5 Suppose an iterative method manages to optimize this function with two steps, starting with an initial design at x = (3,2). In...
-
For each equation, (a) Write it in slope-intercept form (b) Give the slope of the line (c) Give the y-intercept (d) Graph the line. 7x - 3y = 3
-
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...
-
The CEO of ABC Inc. is dynamic and visionary in every area but one. He does not believe in providing corporate training to his personnel. In fact, he is fond of saying, I hire personnel and pay them...
-
Give an example of internal politics in action in an organization.
-
Describe the impact internal politics can have on the implementation of total quality.
Study smarter with the SolutionInn App