Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On a Friday afternoon in February 2010, Jose Ramos, VP of manufacturing at FoldRite Furniture Company of Aurora Colorado, stopped by the office of Martin

image text in transcribedimage text in transcribedOn a Friday afternoon in February 2010, Jose Ramos, VP of manufacturing at FoldRite Furniture Company of Aurora Colorado, stopped by the office of Martin Kelsey, recently hired production manager, to discuss developments of the day. The conference call with sales managers that morning revealed that market demand for FoldRites products was unexpectedly high. However, this good news placed a burden on the firms operations management, which had to optimize the use of manufacturing resources while meeting quality standards and delivery requirements. Ramos looked to Kelsey to develop a production plan for the next six months based on the new forecast. Background: Founded in 1987, FoldRite soon developed a reputation for innovation with the introduction of light and durable folding tables and stackable chairs. By the late 1990s, FoldRite sold three product lines into a range of markets including business and government offices, hotels, convention centers and schools. Revenue increased from $47.5M in 1999 to $60.3M in 2006, representing an annual aggregate growth rate of 3.5%. The year 2006 however brought a financial turmoil. One major cause, management later concluded, was the loss of productivity and yields caused by high turnover rate among factory workers and the increase in the number of inexperienced workers. By the end of 2006, the lead time reached 6-8 weeks up from a norm of 4 weeks- and on-time delivery dropped to 30-40% from an average of over 90%. In an increasingly competitive marketplace, the missed deliveries resulted in the loss of orders. In 2007, a group of private investors took over the company and recruited a new CEO, Marcel Epstein, who had substantial skills in sales, marketing and executive management. Coming from a consumer service background, Epstein was quick to realize the need for innovation and customer service. He hired a new manufacturing VP, Jose Ramos, and together they came up with a set of strategic policies. They reduced the number of products and consolidated manufacturing from four smaller facilities into one. This freed up capital that enabled the purchase of new automation tools, and reduced delivery times and improved margins. Products: At the start of 2010, FoldRite had just one product in each of its three product categories: 1. AlStrong: A folding table in which recycled aluminum replaced the plastic top of the preceding generation of tables. Alstrong provides almost 42% of the company revenues (see Exhibit 1). 2. GreenComfort: A washable and stackable chair upholstered with a specially coated washable facric. GreenComfort provides around 34% of the company revenues (see Exhibit 1). 3. CloudChair: A folding chair providing comfortable seating even for overweight people. The rest of the company income comes from this product. To achieve short lead times, the company maintains a strategic inventory of fully assembled products and partially assembled parts to cover 2 weeks of forecast demand. The factory in Aurora operates in 10 hours shift for 4 days of the week, for a total of 40 hours a week. Fridays are set aside to increase production using overtime and / or extra labor if necessary, and to perform maintenance on machineries. Accounting for holidays, the company planned 200 regular production days per year, and each month corresponds to 18 regular days on average. Workforce: Skilled laborers perform tasks such as thermal forming and robotic welding. Unskilled workers also perform a variety of jobs including assembly, inventory control and warehousing. All workers make an average of $19 per hour plus benefits that cost the company a total of $25 per worker-hour. Currently a total of 60 workers are employed in the manufacturing facility, corresponding to 600 labor hours per production day and 60*10*18 = 10800 regular production hours per month. Manufacturing and Assembly Process: The products use similar materials, which reduced the number of suppliers and the procurement overhead, and increased quality. For all types of production, the tasks that generated the components proceed simultaneously and bring components together for subassembly, and subassemblies together for final assembly, to minimize work-in-progress inventory. Final assembly of the products take place on moving conveyers, with the exception of customized products such as chairs with unusual color combinations. All production planning is highly centralized. The production planner assigned workers to various tasks based on daily production plans derived from the weekly plan. Daily production goals are set to fulfill confirmed orders and keep inventory constant. The company has sufficient workers to manufacture the annual forecast demand (Exhibit 2) over the 200 regular production days in 2010, perhaps with some overtime. The actual hours each worker works is determined based on actual demand. Forecast: Monday morning Kelsey began collecting information for his report from a number of FoldRite managers. Anthony Fasono, the VP of sales, provided him with his forecast for the rest of the year for all three products as well as the actual volume of the products shipped in 2009 (see Exhibit 2). Fasono was especially concerned about CloudChair. He told Kelsey, the chair has generated great buzz in the market. Manufacturing has got to meet the productivity goals because this kind of an opportunity might not come again for a long time. He added that customers are likely to cancel orders if the company failed to deliver within two weeks. Later Kelsey talked to Alice Jung, the CFO. Jung reminded him that the credit is tight, therefore a large outlay of cash for inventory would add costs in terms of borrowing from the credit line, as well as decrease the product development and R&D budgets. Jung provided Kelsey with the average production costs and labor requirements of the products (Exhibit 3). Kelsey then discussed hiring factory workers with Mary Jane Montague, the HR manager. Montague said hiring a worker would cost $1500 in recruiting and administrative expenses. Firing a worker would mean paying indemnification fees, which corresponds to an average of $100 per month the worker has been employed. Production Planning: After Kelsey had acquired the necessary information, he found out that the viable options to meet demand include the following: use of overtime by asking the staff to work an extra shift (e.g. a 10-hour shift on Fridays): the labor costs per extra hour is $35 per worker. increasing the number of staff starting in April until August, to take advantage of idle production capacity: this option involves building inventory using a constant level of production. The forecast demand is at its peak level from April to August, therefore the extra workforce needs to be used during this period (i.e. the workforce level should be equivalent to the average requirement between April and August). The inventory holding cost is estimated as $10 per unit labor hours used to produce it. subcontracting some of the production of GreenComfort: This option would add an extra 30% to the labor cost for the production of the subcontracted units, but given the current state of the economy, FoldRite does not have to pay a set-up fee or commit to minimum orders. The team could also consider a combination of these options.

Discussion Questions:

image text in transcribedimage text in transcribed

1. Develop the cost analysis plans for overtime, hiring and subcontracting options. Which one of these plans looks to be the most economic option? (Hint: You might try to express all costs based on how many labor hours will be necessary to satisfy the forecasts starting with March until the end of December.)

2009 2010 (estimate) ($1000's 7 of Rev ($1000's)|Z of Rev Sales Foldable Tables (AIStrong) Stackable Chairs (GreenComfort) Foldable Chairs ###### ###### ###### 44.37. $27,622 35.47 $22,314 20.37 $15,728 427 347 247 ###### $65,665 Total Sales Cost of Goods: Raw Materials ###### Labor $6,404 $35,940 $7,345 Gross margin ###### 337 $22,380 34% Expenses Sales & Marketing Expense Product Development Continued Engineering G&A Facilities: Rent & Utilities Repair & Maintenance IT & Supplies Shipping Office Supplies Legal & Professional Insurance Licenses & Permits Travel & Entertainment Depreciation Operating Expenses $9,137 $2.767 $600 $2,409 $430 $132 $101 $1,980 $12 $108 $178 $10 $788 $397 ###### 157 $9,850 57 $2,100 17 $650 47 $2,499 17 $530 $133 OZ $121 37 $2,699 OX $12 0% $112 OZ $198 OX $10 17 $821 17 $397 317 $19,735 157 37 17. 47 17 0% 07 47 07 0% 0% OZ 17 17 30% Operating Income $1,565 37 $2,645 47 Interest Income (expense) Taxes (estimate) Net Income ($163) $330 $675 SER ($173) 17 $850 17 $1225 O/ 17 27 hw6exhibits - Microsoft Excel = 5 2 H XE 27 II HH F ELD H H = * FTI = A A- 11 - Calibri - .00 4.0 .0 .00 % - $ $ = = = * UIB 2 + * 1 H17 : X fic R 1400 agar se a guar E | A B C D E F G H | J K k L M N 0 P C 42 Case Exhibit 2: Average Daily & Annual Production 43 Average Daily Production Annual Volume 44 2010 2010, Forecast Forecast 45 Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec. 46 CloudChair 280 1000 2500 4100 4350 4400 4800 3950 2000 1500 900 900 524,280 47 AlStrong 1176 1190 1500 1650 1900 2000 1800 1750 1500 1300 1100 306,916 48 Green Comfort 1060 1102 1260 1400 1500 1550 1400 1250 1250 1250 1100 1000 253,570 49 Production days 16 15 18 18 15 18 18 17 17 18 16 14 200 50 51 52 2010 2010, Forecast 53 Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec. average average (from april to august) 54 aggregate units to be produced per day (in minutes) 35600 42000 46500 48300 45200 41400 34500 32300 28400 25000 55 required labor hours (per day) 593.3333 700 775 805 753.333 690 575 538.333 473.333 416.667 632 744.667 56 required labor force (per day) 59.33333 70 77.5 80.5 75.3333 69 57.5 53.8333 47.3333 41.6667 63.2 74.4667 57 58 Case Exhibit 3: Average Manufacturer's Price (AMP) and Cost of Manufacturing for FoldRite Products 59 AMP Raw Mat Required Labor Net revenue calculation 60 Minutes/item Labor cost Margin 61 62 CloudChair $30$ 11.73 2 $1 $17.27 63 AlStrong 5901 49.70 12 $5 $35.30 64 Green Comfort $881$ 50.24 10 $4 $ $33.76 65 66 67 Sheet1 + 87% + |E B B 1 Type here to search 0 ILL W x 71F Mostly cloudy ENG ( 0 3:06 AM 3/5/2022 2009 2010 (estimate) ($1000's 7 of Rev ($1000's)|Z of Rev Sales Foldable Tables (AIStrong) Stackable Chairs (GreenComfort) Foldable Chairs ###### ###### ###### 44.37. $27,622 35.47 $22,314 20.37 $15,728 427 347 247 ###### $65,665 Total Sales Cost of Goods: Raw Materials ###### Labor $6,404 $35,940 $7,345 Gross margin ###### 337 $22,380 34% Expenses Sales & Marketing Expense Product Development Continued Engineering G&A Facilities: Rent & Utilities Repair & Maintenance IT & Supplies Shipping Office Supplies Legal & Professional Insurance Licenses & Permits Travel & Entertainment Depreciation Operating Expenses $9,137 $2.767 $600 $2,409 $430 $132 $101 $1,980 $12 $108 $178 $10 $788 $397 ###### 157 $9,850 57 $2,100 17 $650 47 $2,499 17 $530 $133 OZ $121 37 $2,699 OX $12 0% $112 OZ $198 OX $10 17 $821 17 $397 317 $19,735 157 37 17. 47 17 0% 07 47 07 0% 0% OZ 17 17 30% Operating Income $1,565 37 $2,645 47 Interest Income (expense) Taxes (estimate) Net Income ($163) $330 $675 SER ($173) 17 $850 17 $1225 O/ 17 27 Case Exhibit 2: Average Daily & Annual Production Mar May Sept CloudChair AlStrong GreenComfort Production days 2010 Jan Feb 280 1000 1176 1190 1060 1102 16 15 Average Daily Production 2010, Forecast Apr Jun Jul Aug 2500 4100 4350 4400 4800 3950 1500 16501 1900 2000 1800 1750 1260 1400 1500 1550 1400 1250 18 18 15 181 18 181 17 Annual Volume Forecast Oct Nov Dec. 2000 1500 900 900 524,280 1500 1400 1300 1100 306,916 1250 1250 1100 1000 253,570 17 18 16 14 200 2010 Jan Feb aggregate units to be produced per day (in minutes) required labor hours (per day) required labor force (per day) 2010, Forecast Mar Apr May Jun Jul Aug Sept Oct Nov Deo. average average (from april to august) 35600 42000 46500 48300 45200 41400 34500 32300 28400 25000 593.333 700 775 805 753.33 690 575 538.33 473.33 416.67 632 744.67 59.3333 70 77.5 80.5 75.333 69 57.5 53.833 47.333 41.667 63.2 74.467 Case Exhibit 3: Average Manufacturer's Price (AMP) and Cost of Manufacturing for FoldRite Products AMP Ray May Required Labor Net revenue calculation Minuteslitem Labor cost Margin CloudChair AIStrong GreenComfort $30 11.73 $ $90 $ 49.70 $88 $ 50.24 2 12 10 $1 $5 $4 $17.27 $35.30 $33.761 2009 2010 (estimate) ($1000's 7 of Rev ($1000's)|Z of Rev Sales Foldable Tables (AIStrong) Stackable Chairs (GreenComfort) Foldable Chairs ###### ###### ###### 44.37. $27,622 35.47 $22,314 20.37 $15,728 427 347 247 ###### $65,665 Total Sales Cost of Goods: Raw Materials ###### Labor $6,404 $35,940 $7,345 Gross margin ###### 337 $22,380 34% Expenses Sales & Marketing Expense Product Development Continued Engineering G&A Facilities: Rent & Utilities Repair & Maintenance IT & Supplies Shipping Office Supplies Legal & Professional Insurance Licenses & Permits Travel & Entertainment Depreciation Operating Expenses $9,137 $2.767 $600 $2,409 $430 $132 $101 $1,980 $12 $108 $178 $10 $788 $397 ###### 157 $9,850 57 $2,100 17 $650 47 $2,499 17 $530 $133 OZ $121 37 $2,699 OX $12 0% $112 OZ $198 OX $10 17 $821 17 $397 317 $19,735 157 37 17. 47 17 0% 07 47 07 0% 0% OZ 17 17 30% Operating Income $1,565 37 $2,645 47 Interest Income (expense) Taxes (estimate) Net Income ($163) $330 $675 SER ($173) 17 $850 17 $1225 O/ 17 27 hw6exhibits - Microsoft Excel = 5 2 H XE 27 II HH F ELD H H = * FTI = A A- 11 - Calibri - .00 4.0 .0 .00 % - $ $ = = = * UIB 2 + * 1 H17 : X fic R 1400 agar se a guar E | A B C D E F G H | J K k L M N 0 P C 42 Case Exhibit 2: Average Daily & Annual Production 43 Average Daily Production Annual Volume 44 2010 2010, Forecast Forecast 45 Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec. 46 CloudChair 280 1000 2500 4100 4350 4400 4800 3950 2000 1500 900 900 524,280 47 AlStrong 1176 1190 1500 1650 1900 2000 1800 1750 1500 1300 1100 306,916 48 Green Comfort 1060 1102 1260 1400 1500 1550 1400 1250 1250 1250 1100 1000 253,570 49 Production days 16 15 18 18 15 18 18 17 17 18 16 14 200 50 51 52 2010 2010, Forecast 53 Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec. average average (from april to august) 54 aggregate units to be produced per day (in minutes) 35600 42000 46500 48300 45200 41400 34500 32300 28400 25000 55 required labor hours (per day) 593.3333 700 775 805 753.333 690 575 538.333 473.333 416.667 632 744.667 56 required labor force (per day) 59.33333 70 77.5 80.5 75.3333 69 57.5 53.8333 47.3333 41.6667 63.2 74.4667 57 58 Case Exhibit 3: Average Manufacturer's Price (AMP) and Cost of Manufacturing for FoldRite Products 59 AMP Raw Mat Required Labor Net revenue calculation 60 Minutes/item Labor cost Margin 61 62 CloudChair $30$ 11.73 2 $1 $17.27 63 AlStrong 5901 49.70 12 $5 $35.30 64 Green Comfort $881$ 50.24 10 $4 $ $33.76 65 66 67 Sheet1 + 87% + |E B B 1 Type here to search 0 ILL W x 71F Mostly cloudy ENG ( 0 3:06 AM 3/5/2022 2009 2010 (estimate) ($1000's 7 of Rev ($1000's)|Z of Rev Sales Foldable Tables (AIStrong) Stackable Chairs (GreenComfort) Foldable Chairs ###### ###### ###### 44.37. $27,622 35.47 $22,314 20.37 $15,728 427 347 247 ###### $65,665 Total Sales Cost of Goods: Raw Materials ###### Labor $6,404 $35,940 $7,345 Gross margin ###### 337 $22,380 34% Expenses Sales & Marketing Expense Product Development Continued Engineering G&A Facilities: Rent & Utilities Repair & Maintenance IT & Supplies Shipping Office Supplies Legal & Professional Insurance Licenses & Permits Travel & Entertainment Depreciation Operating Expenses $9,137 $2.767 $600 $2,409 $430 $132 $101 $1,980 $12 $108 $178 $10 $788 $397 ###### 157 $9,850 57 $2,100 17 $650 47 $2,499 17 $530 $133 OZ $121 37 $2,699 OX $12 0% $112 OZ $198 OX $10 17 $821 17 $397 317 $19,735 157 37 17. 47 17 0% 07 47 07 0% 0% OZ 17 17 30% Operating Income $1,565 37 $2,645 47 Interest Income (expense) Taxes (estimate) Net Income ($163) $330 $675 SER ($173) 17 $850 17 $1225 O/ 17 27 Case Exhibit 2: Average Daily & Annual Production Mar May Sept CloudChair AlStrong GreenComfort Production days 2010 Jan Feb 280 1000 1176 1190 1060 1102 16 15 Average Daily Production 2010, Forecast Apr Jun Jul Aug 2500 4100 4350 4400 4800 3950 1500 16501 1900 2000 1800 1750 1260 1400 1500 1550 1400 1250 18 18 15 181 18 181 17 Annual Volume Forecast Oct Nov Dec. 2000 1500 900 900 524,280 1500 1400 1300 1100 306,916 1250 1250 1100 1000 253,570 17 18 16 14 200 2010 Jan Feb aggregate units to be produced per day (in minutes) required labor hours (per day) required labor force (per day) 2010, Forecast Mar Apr May Jun Jul Aug Sept Oct Nov Deo. average average (from april to august) 35600 42000 46500 48300 45200 41400 34500 32300 28400 25000 593.333 700 775 805 753.33 690 575 538.33 473.33 416.67 632 744.67 59.3333 70 77.5 80.5 75.333 69 57.5 53.833 47.333 41.667 63.2 74.467 Case Exhibit 3: Average Manufacturer's Price (AMP) and Cost of Manufacturing for FoldRite Products AMP Ray May Required Labor Net revenue calculation Minuteslitem Labor cost Margin CloudChair AIStrong GreenComfort $30 11.73 $ $90 $ 49.70 $88 $ 50.24 2 12 10 $1 $5 $4 $17.27 $35.30 $33.761

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions