The office manager of a large New York City-based accounting firm needs to replace the aging...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The office manager of a large New York City-based accounting firm needs to replace the aging and out-of-style office furniture in their New York 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. Nashawtuc 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 $20,000. 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 $13,000. a) 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. Make sure to follow the three steps clearly. b) Use Excel to find the optimal solution. Turn in your spreadsheet. c) In your Word/ PDF file, report how many furniture sets to order from each supplier. In your Word/ PDF file, report what the total cost will be. d) The office manager of a large New York City-based accounting firm needs to replace the aging and out-of-style office furniture in their New York 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. Nashawtuc 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 $20,000. 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 $13,000. a) 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. Make sure to follow the three steps clearly. b) Use Excel to find the optimal solution. Turn in your spreadsheet. c) In your Word/ PDF file, report how many furniture sets to order from each supplier. In your Word/ PDF file, report what the total cost will be. d)
Expert Answer:
Answer rating: 100% (QA)
a Formulate a mixed integer optimization model to minimize co... View the full answer
Related Book For
Financial and Managerial Accounting the basis for business decisions
ISBN: 978-0078111044
16th edition
Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello
Posted Date:
Students also viewed these accounting questions
-
As resident manager of a large apartment complex, you receive free rent in return for collecting rents, doing simple maintenance, and enforcing the complexs rules. You find the following notice in...
-
The sales manager of a large automotive parts distributor, Hartman Auto Supplies, wants to develop a model to forecast as early as May the total annual sales of a region. If regional sales can be...
-
The marketing manager of a large truck manufacturer was surprised to learn that the price lists generated by his department had little relation to the prices that were actually charged to customers....
-
Write a short report in which you assess the impact of one piece of health and safety legislation in an organisation of your choice.
-
Bledel Company had accounts receivable of $100,000 on January 1, 2010. The only transactions that affected accounts receivable during 2010 were net credit sales of $1,000,000, cash collections of...
-
Two fair dice, one red and one blue, are rolled. A score is calculated to be twice the value of the blue die if the red die has an even value, and to be the value of the red die minus the value of...
-
Esparto Ltd (E) is a paper and cardboard manufacturing company whose year-end is 31 March 1989. The auditors are visiting the company early in January 1989 in order to plan their audit approach for...
-
For each of the following, identify (1) Which accounting standardssetting body has primary authority, (2) The required financial statements, and (3) The account titles used in the equity section of...
-
2. Create a scatterplot. Carefully label and scale the axes. Describe the direction and strength. Foot length 14 Test Score 56 67 15 16 87 97 17 88 18 19 94 20 87 21 79 22 64 23 66 24 89 Don't forget...
-
David R. and Ella M. Cole (ages 39 and 38, respectively) are husband and wife who live at 1820 Elk Avenue, Denver, CO 80202. David is a self-employed consultant, specializing in retail management and...
-
Hollow purchased a mineral deposit for $505,000 in May, 2024. In June, Hollow spent $35,000 to prepare for the exploitation. The mineral deposit was ready for exploitation on July 1. Hollow estimated...
-
Identify any barriers to successfully implementing the best practice or process. In addition to the obvious, this could also include such matters as stakeholder conflict over what project management...
-
A chicken egg (m = 50g) and an ostrich egg (m = 3kg) were putinto the boiling water at the same time, and the chicken egg was hardboiled after 5 min. How longwill it take for the ostrich egg to be...
-
Q6 (a) Discuss the continuity of the following function at x=2 x-4 f(x)=2 x-2 when 0 < x <2 when x = 2 3x+2 when x> 2 X (b) Find lime when xa from the left hand side as well as from the right 04-1...
-
Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs...
-
2) A short range rocket is launched, and its height (in feet) above sea level t seconds after launch is given by the following function: h(t) = -4.9t + 1500t + 570. a) At what time (rounded to the...
-
1 pts Question 9 You are the CM of a construction company, and you need to determine the amount of the general overhead that should be allocated to your project. You have the following data...
-
Write a paper about how diet relates to breast cancer in women study design to use: case control study purpose & rationale the purpose of this final project is to utilize the methods and...
-
Selected items from successive annual reports of Carey, Inc., appear as follows: Dividends of $16,000 were declared and paid in 2011. Compute the following: a. Current ratio for 2011 and 2010. b....
-
Bill Gladstone has owned and operated Gladstones Service Station for over 30 years. The business, which is currently the towns only service station, has always been extremely profitable. Gladstone...
-
Who are the sponsoring organizations of COSO, and what is COSO best known for doing?
-
When an investment bank underwrites an issue of new shares, it charges the issuing company a commission. How is this commission analysed using options theory?
-
What purpose does a Dutch clause serve?
-
What power does a shareholder with a blocking minority have?
Study smarter with the SolutionInn App