Question

BF SWINGS

Ben Floyd really enjoyed wood shop in high school, so he used an inheritance to buy some basic woodworking tools. He started out doing odd jobs, and then one day he made a porch swing for his house. Several people saw it and asked him to make one for them. Word of mouth brought him many customers. In June of 1991 he married Bobbie Ruth, a marketing graduate. Bobbie Ruth saw a chance to expand the swing business to similar products and eventually have hardware, building supply, and furniture stores. Thus, BF Swing was born. Due to his love of his work and Bobbie Ruth’s marketing ability, the business prospered. Today, they make stools and rockers as well as swings.

The company now employs about 35 people five days a week with sales close to $1.4 million dollars. Ben is concerned with production for the next few months, and he assigns you to come up with a four-week production plan. Part of his motivation is that he thinks there is too much inventory. Samir, the forman, contends that cannot be true, because the storage area is limited, and there can never be more than 500 total items in storage at any one time. Another motivation is that Lupe, the accountant, tells him that overtime costs are a large part of his total operating costs. Chan, from the personnel, thinks they ought to hire more workers to alleviate overtime.

When asked, Chan admits it will cost $1000 per worker to train them, and their wages are $400 per week. Bobbie Ruth points out that, by law, any worker laid off must be paid three weeks’ separation pay. Overtime costs are approximately double the cost of regular time in each department and that overtime work can be at most three hours a working day (Monday to Friday) and 6 hours on Saturday. Samir also reminds them that adding people might not add capacity, because additional equipment may also be needed. Ben agrees with this except in the case of sanding, assembly, and finishing, which require little or no equipment.

Therefore they conclude that hiring only make sense in these 3 departments. Thanks to Bobbie Ruth’s foresight, some data are available. The following table gives the standard processing time (in minutes) for each “operation” of the three products. It contains the expected time available in each department per worker. (Time for preventative and unexpected maintenance is already excluded.) The number of employees currently working in the department is also provided, as well as the average costs per hour (including labour and machine costs).

Processing time (minutes) Available Department Stool Rocker SwingHours/Worker/Week Workers |Cost in S/hour Drill Lathe Crossc

Inventory holding costs per week are $0.30, $0.80, and $0.90 per unit-week. Currently, there are 70 stools, 255 rockers, and 110 swings in inventory. The forecasted demands for products in the next four weeks are as follows:

Week Stools Rockers Swings 100 109 90 106 344 352 368 361 24 146 279 64 2 4

Develop a four-week production plan for BFS that minimizes the total cost (production, labor, hiring, layoffs, extra hours and storage cost).

A. Deliver the working document (Lingo or Excel) with the solution of the problem.
B. If an optimization model is used, show the model and the decision variables.
C. Make a summary table that indicates the amount to be produced each month, the initial inventory and the initial inventory for each week.
D. Also make a table of available labor in each process, those hired, laid off extra times each week.
E. Calculate the total cost per week for each of the three products and the total cost of all production.

Processing time (minutes) Available Department Stool Rocker SwingHours/Worker/Week Workers |Cost in S/hour Drill Lathe Crosscut saw Rip saw Mortise Tenon Router/shaper 0 Plane Sand Assemble Finish 10 35 35 35 35 35 35 35 35 36 37 40 12 15 12 12 20 20 15 15 15 10 0 0 0 10 13 25 30 15 35 45 4 4 12 10 10
Week Stools Rockers Swings 100 109 90 106 344 352 368 361 24 146 279 64 2 4
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Given beloo kinDacomene 3f an optimization model is osed, shocs ihe madel and he decision vasiables c. mak: a table of availa7 Bedict (ft, », ahead -s Spse Time sexics; End 121 [1] 109,0502 103, 2318 103. 3400 03. 4827 0 G156 to3. 755] se Time sesics

Add a comment
Know the answer?
Add Answer to:
BF SWINGS Ben Floyd really enjoyed wood shop in high school, so he used an inheritance to buy som...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 109 CASE STUDY Dream Desk Compary Dream Desk Company is a major supplier of office desks for can ...

    109 CASE STUDY Dream Desk Compary Dream Desk Company is a major supplier of office desks for can profit from this market growth if prices can be held in line home and business. The company has been in existence since 1875. Affler serving an apprenticeship as a cabinet maker in the and quick delivery can be promised. Dream Desk operates a 250,000 sq. ft. manufacturing fa- cast, George Dreamer had a violent disagreement with the shop eility in Casa Petite,...

  • Comprehensive Income Tax Course: Module 1 4. Randy turned 16 last year and had his first...

    Comprehensive Income Tax Course: Module 1 4. Randy turned 16 last year and had his first summer job. Even though his parents are claiming him as a dependent he wants to file a return in order to get his refund. He receives his W-2 and decides he can do his own return using form 1040-EZ. Which of the following information is not found on a Form W-2? a) The taxpayer’s Social Security number b) The taxpayer’s wages, tips and other...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT