Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The office manager of a large New York-based firm needs to replace the aging and out-of-style office furniture in their offices. The firm has decided

The office manager of a large New York-based firm needs to replace the aging and out-of-style office furniture in their offices. The firm has decided to purchase desk/chair/credenza furniture sets for all 2,000 offices in New York. The company has received bids from four different furniture companies who are willing to supply the furniture sets, as follows:

Carolina Woodworks has bid to deliver up to 1,000 furniture sets at a cost of $2,500 per set and with a one-time charge of $10,000.

Niagara Millworks has bid to deliver up to 1,200 furniture sets at a cost of $2,450 per set and with a one-time charge of $17,500.

Adirondack Furnishing Designs has bid to deliver up to 800 furniture sets at a cost of $2,510 per set with no additional charges.

Lancaster Artisan Company has bid to deliver up to 1,100 furniture sets at a cost of $2,470 per set and with a one-time charge of $12,500.

Formulate a mixed integer optimization model that could be used to determine how many furniture sets to purchase from each of the four potential suppliers in order to minimize cost. use excel solver to find the optimal solution. please submit the spreadsheet and answer the following question a. how many furniture sets should we order from each supplier?

^ I have solved this part, may I know how to carry on to solve:

Suppose that a fifth company, Delta Furnishing, has submitted a bid to supply up to 1,000 furniture sets at a cost of $2,530 per set and a one-time delivery charge of $9,000. However, if the firm purchases between 1,000 and 1,500 furniture sets from Delta Furnishing Finishing, then Dela Finishing will charge the firm only $2,430 for any and all additional furniture sets beyond the 1,000, and with an additional delivery charge of only $7,000. Incorporate this new bid into your model and evaluate the optimal purchasing strategy.

Note: This means that 1-1000: n*$2530+$9000 1001-1500: n*$2430+$9000+$7000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services Plus Pearson MyLab Accounting With Pearson EText

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

17th Global Edition

1292312106, 978-1292312101

More Books

Students also viewed these Accounting questions