Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Requesting help with understanding how to input the given data in the attached screenshot into a solver parameter. There is a screenshot attached with the

Requesting help with understanding how to input the given data in the attached screenshot into a solver parameter. There is a screenshot attached with the given data and the bolded area are the requirements to put into the solver parameter. I have no clue what to do.

________________________________________________________

Many young people moving into apartments and new homes look forward to the excitement of furniture shopping. These young shoppers are usually interested in cheaper, build yourself furniture, however, many of them are not too handy and the excitement quickly dissipates as they start putting their furniture together. The instructions, even if they are in English, are difficult to understand and the consumer soon realizes that the savings may not be worth the hassle. Built-4-U is an online furniture company that caters to those customers. Built-4-U buys build yourself furniture directly from manufacturers at a discount price, assembles each piece at their warehouse, and then ships directly to their customers. Each customer can order their furniture online without ever having to leave their home or search for the right tool to assemble. Joe Builder, the owner and CEO of Built-4-U, plans to establish their beginning inventory by investing a maximum of $35,000 on 25 popular items. The website for Built-4-U is scheduled to go live shortly and all 4 inventory clerks were advised they might have to work five, 10 hour days prior to the grand opening to assemble this startup inventory. Joe believes he should order no less than 5 and no more than 20 units of each item. In addition, the manufacturer has a minimum truck order of 6,000 pounds. Given the following information, help Joe decide how many units of each item to order.

Plans to establish their beginning inventory by investing a maximum of $35,000 on 25 popular items

Four inventory clerks advised they might have to work five, 10 hour days

Joe believes he should order no less than 5 and no more than 20 units

Minimum truck order of 6,000 pounds

Given the following information, help Joe decide how many units of each item to order.

image text in transcribed
A B C D E Item Oak Cabinet Wholesale Price Retail Price Weight 209.00 Minutes of Assembly Oak Low Chair 369.00 35 80 49.00 Oak Gateleg Table 99.00 12 25 249.00 Oak Buffet with Top Cabinet 449.00 39 90 Oak Buffet 179.00 339.00 30 90 159.00 Oak Chair 299.00 55 Black Cherry Sideboard 59.00 109.00 13 Black Cherry Wall Cabinet 209.00 20 399.00 35 129.00 90 10 Black Cherry Dining Table 239.00 23 45 209.00 Black Cherry Chair 399.00 35 90 59.00 Black Cherry Coffee Table 109.00 13 20 119.00 Black Cherry Coffee Table Oval 229.00 22 50 99.00 14 Maple Round Coffee Table 189.00 19 45 5 Maple Oval Coffee Table 99.00 189.00 17 45 Maple Visitor Chair 89.00 179.00 18 89.00 45 Mahogany Chair 179.00 20 45 69.00 Mahogany Low Chair 149.00 15 45 59.00 Resewood Chair 119.00 14 20 55.00 10 Rosewood Wardrobe 109.00 13 20 209.00 21 Rosewood Linen Cupboard 379.00 35 70 139.00 Rosewood Chest with 3 Drawers 269.00 25 23 139.00 65 Rosewood Chest with 7 Drawers 269.00 2B 499.00 70 Rosewood Wardrobe with 3 Doors 879.00 82 24 90 289.00 46 Rosewood Wardrobe with Sliding Doors 499.00 25 75 16 329.00 Rosewood Bed with Storage 559.00 51 75 27 179.00 319.00 32 65

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

Intermediate Accounting

Authors: David Spiceland

11th Edition

1264134525, 9781264134526

More Books

Students also viewed these Accounting questions

Question

How do the events of normal aging affect life satisfaction?

Answered: 1 week ago

Question

6. How can a message directly influence the interpreter?

Answered: 1 week ago