Use with solver parameter Given the following information, help Joe decide how many units of each item
Fantastic news! We've Found the answer you've been seeking!
Question:
Use with solver parameter
Given the following information, help Joe decide how many units of each item to order.
Maximum of $35,000 on 25 items
Work five, 10 hour days
Order no less than 5 and no more than 20 units of each item
Minimum truck order of 6,000 pounds
Transcribed Image Text:
A 1 Inventory Clerks 2 Work Days 3 Work Hours 4 Maximum Cost 5 Minimum Truck Order Pounds 6 Order no less than 5 but no more than 20 7 8 9 10 11 Oak Cabinet 12 Oak Low Chair 13 Oak Gateleg Table 14 Oak Buffet with Top Cabinet 15 Oak Buffet 16 Oak Chair 17 Black Cherry Sideboard 18 Black Cherry Wall Cabinet 19 Black Cherry Dining Table 20 Black Cherry Chair 21 Black Cherry Coffee Table 22 Black Cherry Coffee Table Oval 23 Maple Round Coffee Table Item 24 Maple Oval Coffee Table 25 Maple Visitor Chair 26 Mahogany Chair 27 Mahogany Low Chair 28 Resewood Chair 29 Rosewood Wardrobe 30 Rosewood Linen Cupboard 31 Rosewood Chest with 3 Drawers 32 Rosewood Chest with 7 Drawers 33 Rosewood Wardrobe with 3 Doors 34 Rosewood Wardrobe with Sliding Doors 35 Rosewood Bed with Storage 36 B 4 5 10 35000 6000 3971.00 Wholesale Price 209.00 49.00 249.00 179.00 159.00 59.00 209.00 129.00 209.00 59.00 119.00 99.00 99.00 89.00 89.00 69.00 59.00 55.00 209.00 139.00 139.00 499.00 289.00 329.00 179.00 с 7325.00 Retail Price 369.00 99.00 449.00 339.00 299.00 109.00 399.00 239.00 399.00 109.00 229.00 189.00 189.00 179.00 179.00 149.00 119.00 109.00 379.00 269.00 269.00 879.00 499.00 559.00 319.00 D Total Available Hours Total Available Minutes 700 Weight 35 12 39 30 28 13 35 23 35 13 22 19 17 18 20 15 14 13 35 25 28 82 46 51 32 E 200 12000 Minutes of Assembly 80 25 90 90 65 20 90 45 90 20 50 45 45 45 45 45 20 20 70 65 70 90 75 75 65 F QTY G Cost H Weight 1 Assemly Time A 1 Inventory Clerks 2 Work Days 3 Work Hours 4 Maximum Cost 5 Minimum Truck Order Pounds 6 Order no less than 5 but no more than 20 7 8 9 10 11 Oak Cabinet 12 Oak Low Chair 13 Oak Gateleg Table 14 Oak Buffet with Top Cabinet 15 Oak Buffet 16 Oak Chair 17 Black Cherry Sideboard 18 Black Cherry Wall Cabinet 19 Black Cherry Dining Table 20 Black Cherry Chair 21 Black Cherry Coffee Table 22 Black Cherry Coffee Table Oval 23 Maple Round Coffee Table Item 24 Maple Oval Coffee Table 25 Maple Visitor Chair 26 Mahogany Chair 27 Mahogany Low Chair 28 Resewood Chair 29 Rosewood Wardrobe 30 Rosewood Linen Cupboard 31 Rosewood Chest with 3 Drawers 32 Rosewood Chest with 7 Drawers 33 Rosewood Wardrobe with 3 Doors 34 Rosewood Wardrobe with Sliding Doors 35 Rosewood Bed with Storage 36 B 4 5 10 35000 6000 3971.00 Wholesale Price 209.00 49.00 249.00 179.00 159.00 59.00 209.00 129.00 209.00 59.00 119.00 99.00 99.00 89.00 89.00 69.00 59.00 55.00 209.00 139.00 139.00 499.00 289.00 329.00 179.00 с 7325.00 Retail Price 369.00 99.00 449.00 339.00 299.00 109.00 399.00 239.00 399.00 109.00 229.00 189.00 189.00 179.00 179.00 149.00 119.00 109.00 379.00 269.00 269.00 879.00 499.00 559.00 319.00 D Total Available Hours Total Available Minutes 700 Weight 35 12 39 30 28 13 35 23 35 13 22 19 17 18 20 15 14 13 35 25 28 82 46 51 32 E 200 12000 Minutes of Assembly 80 25 90 90 65 20 90 45 90 20 50 45 45 45 45 45 20 20 70 65 70 90 75 75 65 F QTY G Cost H Weight 1 Assemly Time
Expert Answer:
Answer rating: 100% (QA)
Question Answer Explanation Create a linear program that maximizes pr... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these general management questions
-
A manager wants to know how many units of each product to produce on a daily basis in order to achieve the highest contribution to profit. Production requirements for the products are shown in the...
-
In this mini-case, you will determine overall materiality as well as tolerable misstatement amounts for balance sheet accounts of EarthWear Clothiers, Inc. Most auditing firms use a simple approach...
-
calculate ending inventory (variable) ($) calculate operating income (absorption) ($) calculate operating income (variable) ($) calculate total assets (absorption) ($) calculate total assets...
-
On July 1, Novak Corporation purchases 570 shares of its $5 par value common stock for the treasury at a cash price of $8 per share. On September 1, it sells 320 shares of the treasury stock for cash...
-
Find the price bounds for the five- month forward price for Boring Unreliable Gadgets when - BUGs stock price S is $50 today - A trader can borrow money at 5 percent and lend money at 4 percent,...
-
Use technology or a Normal table to find each of the following. Include an appropriately labeled sketch of the Normal curve for each part with the appropriate area shaded. a. Find the probability...
-
Question: Shauna flew a World War II fighter aircraft as a member of an exhibition flight team. While the team was performing in a delta formation, another plane collided with Shauna's aircraft,...
-
Zolnick Enterprises has two hourly employees, Kelly and Jon. Both employees earn overtime at the rate of 1 times the hourly rate for hours worked in excess of 40 per week. Assume the Social Security...
-
Please answer both parts of the question and show your work. 4. Testing Services Inc. is expected to have earnings of $6 per share this com?? ing year. It expects earning will grow at 15% for three...
-
As the auditor of Clearwater County you learn that various assets are subject to spending constraints. Indicate how each of the following constraints would affect the countys reported fund balance...
-
Assume that your friend chooses the CommBank Awards credit card. After about six months of using her new card as planned, she suddenly loses her casual job. As a result, she can't repay the full...
-
Unbeknownst to you, Uncle Leo D. Avinci; has left you as the sole beneficiary in his will. Besides an under performing portfolio of investments, he has left you a 20-acre piece of land on the...
-
When using a link on the Mississippi Department of Education Division of Safety and Orderly Schools website and obtain the School Facility Safety Assessment Instrument. Complete this assessment at...
-
Your good friend Claire has finally had it with her husband Frank's shenanigans, and after years of fighting and disharmony, Claire decides to finally call it quits and file for a divorce. She has...
-
How would you explain the chain rule to someone who has no familiarity with calculus? Try to use as little technical terminology as possible in your explanation.
-
Based on the movie "The Circle", answer the following questions: Identify the ethical issue and characterize the ethical culture in the company referred to in the case study in terms of values,...
-
Problem 5-2A (Algo) Record transactions related to credit sales and contra revenues (LO5-1, 5-2) Brooks Expeditions provides guided fishing tours. The company charges $130 per person but offers a 10%...
-
Element compound homogeneous mixture (heterogeneous mixture) 4) A piece of gold has a mass of 49.75 g. What should the volume be if it is pure gold? Gold has a density of 19.3 g/cm (3 points) D=m/v...
-
Indicate the most likely effect of the following changes in inventory management on the inventory turnover ratio (1 for increase, 2 for decrease, and NE for no effect). _____ a. Inventory delivered...
-
Cond Nast is a publisher of magazines. Its accounting policy for subscriptions follows: Revenues Sales of our magazine subscriptions are deferred (as unearned revenue) and recognized as revenues...
-
Ahlers Clocks is a retailer of wall, mantle, and grandfather clocks and is located in the Empire Mall in Sioux Falls, South Dakota. Assume that a grandfather clock was sold for $ 10,000 cash plus 4...
-
From the following balance sheets and further information you are to draw up a consolidated balance sheet as at 31 December \(19 \times 8\). P Balance Sheet as at 31 December 19X8 Fixed assets...
-
A From the following balance sheets and supplementary information you are to draw up a consolidated balance sheet as at 31 December 19X5. P Consolidated Balance Sheet as at 31 December 19X5...
-
\(\quad\) B Balance Sheet as at 31 December \(19 \times 7\) Investment in S: 60,000 shares bought on 31.12.19X6 121,000 Fixed assets 90,000 Less Depreciation for year 24,000 66,000 Current assets...
Study smarter with the SolutionInn App