4. FCC Company manufactures boats and distributes them across the country. Part IE-365 is the most...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. FCC Company manufactures boats and distributes them across the country. Part IE-365 is the most expensive part used in boat production so that its production should be carefully planned. The table below shows the demand forecast for this part for the next 12 months. Labor cost of producing one unit at regular time is $40. Inventory holding and backordering costs are $2 and $4 per unit per month, respectively. 12 Month 12 3 4 5 6 7 8 9 10 11 Demand (units) 300 600 300 400 800 900 1600 1800 800 800 500 800 (a) Suppose that 20 workers are employed in each month, and the monthly output on regular time per person is 50 units. Determine the number of units left in inventory at the end of each month. Calculate the total labor cost, total inventory holding cost, total backordering cost, and the total cost of this constant production plan. Determine the month having the maximum end-of-month inventory. Also, determine the month having the maximum backorder quantity. (b) Using the Microsoft Excel, plot the cumulative demand and the cumulative production over time for the production plan developed in part (a). (c) Suppose that the company do not want to keep no units in inventory at the end of the planning horizon. Determine the constant number of workers to be employed in each month. Determine the number of units left in inventory at the end of each month. Calculate the total labor cost, total inventory holding cost, total backordering cost, and the total cost of this constant production plan. (d) Using the Microsoft Excel, plot the cumulative demand and the cumulative production over time for the production plan developed in part (c). (e) Suppose that the company may vary the work force to meet demand with no units in inventory at the end of each month. Each increase or decrease in the workforce level has a cost of $500 per worker. For this production plan, determine the number of units produced in each month, and the number of workers employed in each month. Calculate the total labor cost, including the cost of change in work force levels, and the total cost of this constant production plan. (f) Which of the plans in parts (a), (c) and (e) do you select for implementation? Why? 4. FCC Company manufactures boats and distributes them across the country. Part IE-365 is the most expensive part used in boat production so that its production should be carefully planned. The table below shows the demand forecast for this part for the next 12 months. Labor cost of producing one unit at regular time is $40. Inventory holding and backordering costs are $2 and $4 per unit per month, respectively. 12 Month 12 3 4 5 6 7 8 9 10 11 Demand (units) 300 600 300 400 800 900 1600 1800 800 800 500 800 (a) Suppose that 20 workers are employed in each month, and the monthly output on regular time per person is 50 units. Determine the number of units left in inventory at the end of each month. Calculate the total labor cost, total inventory holding cost, total backordering cost, and the total cost of this constant production plan. Determine the month having the maximum end-of-month inventory. Also, determine the month having the maximum backorder quantity. (b) Using the Microsoft Excel, plot the cumulative demand and the cumulative production over time for the production plan developed in part (a). (c) Suppose that the company do not want to keep no units in inventory at the end of the planning horizon. Determine the constant number of workers to be employed in each month. Determine the number of units left in inventory at the end of each month. Calculate the total labor cost, total inventory holding cost, total backordering cost, and the total cost of this constant production plan. (d) Using the Microsoft Excel, plot the cumulative demand and the cumulative production over time for the production plan developed in part (c). (e) Suppose that the company may vary the work force to meet demand with no units in inventory at the end of each month. Each increase or decrease in the workforce level has a cost of $500 per worker. For this production plan, determine the number of units produced in each month, and the number of workers employed in each month. Calculate the total labor cost, including the cost of change in work force levels, and the total cost of this constant production plan. (f) Which of the plans in parts (a), (c) and (e) do you select for implementation? Why?
Expert Answer:
Answer rating: 100% (QA)
Answer FCC Company Workers 20 Monthly Output per person 50 Labour cost per unit 40 Inventory holding per unit 2 Backordering cost per unit 4 a Month N... View the full answer
Related Book For
Taxation Of Individuals And Business Entities 2015
ISBN: 9780077862367
6th Edition
Authors: Brian Spilker, Benjamin Ayers, John Robinson, Edmund Outslay, Ronald Worsham, John Barrick, Connie Weaver
Posted Date:
Students also viewed these accounting questions
-
Scheer Companys standard labor cost of producing one unit of Product DD is 4 hours at the rate of $12.00 per hour. During August, 40,800 hours of labor are incurred at a cost of $12.10 per hour to...
-
Cherie Companys standard labor cost of producing one unit of Product DD is 4 hours at the rate of $12.00 per hour. During August, 40,800 hours of labor are incurred at a cost of $12.10 per hour to...
-
Nevitt Companys standard labor cost of producing one unit of Product DD is 4 hours at the rate of $12.00 per hour. During August, 40,800 hours of labor are incurred at a cost of $12.10 per hour to...
-
Axel Corporation acquires 100% of the stock of Wheal Company on December 31, Year 4. The following information pertains to Wheal Company on the date of acquisition: Book Value Fair Value Cash $...
-
The owner of Brooklyn Restaurant is disappointed because the restaurant has been averaging 4,000 pizza sales per month but the restaurant and wait staff can make and serve 6,000 pizzas per month. The...
-
How will you build and sustain competitive advantage? Which of the basic strategic and competitive approaches discussed in this chapter do you think makes the most sense to pursue? What kind of...
-
What are the functions of a kinship system?
-
The file taxdata contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create a PivotTable in Excel to answer the following...
-
Educational Philosophy 10 points Write a brief paper that presents your philosophy on the education of students with disabilities (i.e., your thoughts about access and inclusion in public schools,...
-
Using the data in the student spreadsheet file Ethan Allen financials.XLSX ( to find the student spreadsheets for financial Analysis with Microsoft Excel, eighth edition, go to...
-
Which of the following is a digital transducer? O a. LVDT O b. Strain gauge O c. Thermistor O d. Encoder The 4 bit equivalent value of analog number 11" is. O a. 1001 O b. 1101 O c. 1100 O d. 1011
-
Cost of Goods Manufactured and Sold LeMans Company produces specialty papers at its Fox Run plant. At the beginning of June, the following information was supplied by its accountant: Direct materials...
-
Disney World is a major entertainment complex in Central Florida. It operates, among other things, three theme parks: Magic Kingdom, EPCOT and Animal Kingdom. Each of these parks have their own...
-
A block of wood with a cross-sectional area of 25-cm is fully submerged in a container of water as result of a force (Fadd = 10-N) acting on its top surface. The buoyant force acting on the block...
-
1. Hayward Industries manufactures dining chairs and tables. The controller currently uses traditional costing to allocate overhead to the two product lines based on direct labor hours. However, he...
-
A car leaves point A and drives at 100.0 km/h [E] for 1.2 h. It then heads north at 75.0 km/h for 0.6 h and finally [N42.0W] at 95.0 km/h for 1.0 h, arriving at point B. (a) Determine the distance...
-
Consider the relation R = {(a,b) | a/b = Q} over the R+. Is R reflexive, anti-reflexive, symmetric, anti-symmetric, or transitive? Is it an equivalence relation, a partial order or a strict partial...
-
An educational researcher devised a wooden toy assembly project to test learning in 6-year-olds. The time in seconds to assemble the project was noted, and the toy was disassembled out of the childs...
-
Nancy operates a business that uses the accrual method of accounting. In December, Nancy asked her brother, Hank, to provide her business with consulting advice. Hank billed Nancy for $5,000 of...
-
Laura Li, a U.S. resident, works for three months this summer in Hong Kong. What type of tax authority may be especially useful in determining the tax consequences of her foreign income?
-
What types of taxes qualify to be deducted as itemized deductions? Would a vehicle registration fee qualify as a deductible tax?
-
The double-web girder is constructed from two plywood sheets that are secured to wood members at its top and bottom. The allowable bending stress for the wood is \(\sigma_{\text {allow }}=\) \(8...
-
The double-web girder is constructed from two plywood sheets that are secured to wood members at its top and bottom. If each fastener can support \(600 \mathrm{lb}\) in single shear, determine the...
-
The beam is fabricated from two equivalent structural tees and two plates. Each plate has a height of 6 in. and a thickness of 0.5 in. If the bolts are spaced at \(s=8\) in., determine the maximum...
Study smarter with the SolutionInn App