Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please show working and steps using excel solver? Many young people moving into apartments and new homes look forward to the excitement of

can you please show working and steps using excel solver?
image text in transcribed
image text in transcribed
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. Built-4-U \\begin{tabular}{|l|c|c|c|c|} \\hline \\multicolumn{1}{|c|}{ Item } & Wholesale Price & Retail Price & Weight & Minutes of Assembly \\\\ \\hline Oak Cabinet & 209.00 & 369.00 & 35 & 80 \\\\ \\hline Oak Low Chair & 49.00 & 99.00 & 12 & 25 \\\\ \\hline Oak Gateleg Table & 249.00 & 449.00 & 39 & 90 \\\\ \\hline Oak Buffet with Top Cabinet & 179.00 & 339.00 & 30 & 90 \\\\ \\hline Oak Buffet & 159.00 & 299.00 & 28 & 65 \\\\ \\hline Oak Chair & 59.00 & 109.00 & 13 & 20 \\\\ \\hline Black Cherry Sideboard & 209.00 & 399.00 & 35 & 90 \\\\ \\hline Black Cherry Wall Cabinet & 129.00 & 239.00 & 23 & 45 \\\\ \\hline Black Cherry Dining Table & 209.00 & 399.00 & 35 & 90 \\\\ \\hline Black Cheiry Chair & 69.00 & 109.00 & 13 & 20 \\\\ \\hline Black Cherry Coffee Table & 119.00 & 229.00 & 22 & 50 \\\\ \\hline Biack Cherry Coffee Table Oval & 99.00 & 189.00 & 19 & 45 \\\\ \\hline Maple Round Coffee Table & 99.00 & 189.00 & 17 & 45 \\\\ \\hline Maple Oval Coffee Table & 89.00 & 179.00 & 18 & 45 \\\\ \\hline Maple Visitor Chair & 89.00 & 179.00 & 20 & 45 \\\\ \\hline Mahogany Chair & 69.00 & 149.00 & 15 & 45 \\\\ \\hline Mahogany Low Chair & 59.00 & 119.00 & 14 & 20 \\\\ \\hline Resewood Chair & 209.00 & 109.00 & 13 & 20 \\\\ \\hline Rosewood Wardrobe & 139.00 & 269.00 & 35 & 70 \\\\ \\hline Rosewood Linen Cupboard & 139.00 & 269.00 & 28 & 65 \\\\ \\hline Rosewood Chest with 3 Drawers & 499.00 & 879.00 & 82 & 70 \\\\ \\hline Rosewood Chest with 7 Drawers & 289.00 & 499.00 & 46 & 90 \\\\ \\hline Rosewood Wardrobe with 3 Doors & 179.00 & 569.00 & 51 & 75 \\\\ \\hline Rosewood Wardrobe with Sliding Doors & 319.00 & 32 & 65 \\\\ \\hline Rosewood Bed with Storage & & \\\\ \\hline \\end{tabular}

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

Step: 3

blur-text-image

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

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, George Foster, Srikant M. Datar, Howard D. Teall, Foster Horngren, Data Horngren

3rd Canadian Edition

0130355801, 978-0130355805

More Books

Students also viewed these Accounting questions