Which includes three- and two-seater sofas

Assignment Help Business Management

Reference no: EM133875796

Question

A company produces several types of sofas and ottoman and is launching its new collection, which includes three- and two-seater sofas, sofa-bed, armchair, and ottoman. The data set below shows information regarding costs with production and stock, production and stock capacities, and demand for the next six months. The initial stock of each type of product is 200 units. Use Excel Solver to determine the optimal production plan for the next six months in order to minimize costs with production and stock and respecting all production and stock limitations while meeting the demand for each product. Production and stock costs Product Two-seater sofa Three-seater sofa Sofa-bed Armchair Ottoman Production cost 320 440 530 66 48 Stock cost 8 8 9 3 3 Production and stock capacities Product Two-seater sofa Three-seater sofa Sofa-bed Armchair Ottoman Production capacity 1800 1600 1500 2000 2000 Stock capacity 20000 18000 15000 22000 22000 Demand for the next six months Product Two-seater sofa Three-seater sofa Sofa-bed Armchair Ottoman Jan 1200 1250 1400 1850 1850 Feb 1500 1430 1500 1700 1700 Mar 1400 1650 1200 2100 2050 Apr 1860 1700 1350 2000 1950 May 2000 1450 1600 1850 2050 June 1700 1500 1450.

Reference no: EM133875796

Questions Cloud

Explain the nature of african philosophy : In "African historical reconstruction" Osuagwu identified four factors which he argues characterize and explain the nature of African Philosophy.

Measure quality and give examples of products : What quality means for you and how it affects what you purchase as a consumer, tell us how you measure quality, and give examples of products

Work breakdown structure shall decompose the deliverables : The Work Breakdown Structure shall decompose the deliverables (Adjective, Noun) to at least level 2.

Watch the movie thank you for smoking : It is a fictional movie about a Lobbyist for the tobacco industry in the 90's before the US Government cracked down on the whole industry.

Which includes three- and two-seater sofas : A company produces several types of sofas and ottoman and is launching its new collection, which includes three- and two-seater sofas,

Explain the reader the nature of the fallacy : Define and explain to the reader the nature of the fallacy. Give reasons supporting your position that the fallacy was actually committed.

Describe the monitoring or measuring tools : Describe the monitoring or measuring tools that will be used to determine the success of the elementary school garden project/achieving the desired outcomes

Which fallacy : Which fallacy? Einstein became a great physicist because his parents and his teachers left him alone to dream.

Company plans to make historical communications : A company plans to make historical communications available in timelines of Microsoft Dataverse records

User Account

All Pages