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...
-
A retiree, James Timor, has an asset base of ¬1,900,000. Taking into account annual inflation of 3 percent, taxes of 15 percent, management fees of 50 basis points, his objectives, his...
-
The scatterplot above shows the annual revenue for all of the individual retail stores operated by a clothing company for each year from 2004 through 2012. Based on the line of best fit to the data...
-
A four cylinder, four stroke cycle petrol engine develops \(40 \mathrm{~kW}\) at \(2500 \mathrm{rpm}\). The mean effective pressure is \(0.8 \mathrm{MPa}\) and mechanical efficiency is \(80 \%\)....
-
A renovation of the gift shop at Orlando Amway Center has six activities ( in hours). For the following estimates of a, m, and b, calculate the expected time and the standard deviation for...
-
On January 1 , 2 0 2 2 , Cargo Airlines Inc. ( CAI ) ( uses IFRS and has a December 3 1 year - end ) issued $ 5 , 0 0 0 , 0 0 0 of 4 % bonds which pay interest on June 3 0 and December 3 1 , and...
-
The client memo is distinct from the work in the problem portion (not related). Assume you are hired to complete a feasibility study for a potential hotel near the ballpark in downtown San Diego....
-
Page 2 2. In designing structures and machines, it is important to consider strength of material so that the material should have an adequate strength to resist applied loads or forces and retain its...
-
When you take a hot shower or run hot water on a faucet, the hot water that you use is being generated by a water heater. Residential water heaters typically work by maintaining a large tank of water...
-
A tensile test specimen is loaded to its proportional limit. The specimen has a gauge length of 2.0 inches and a cross- sectional area of 0.25 in. At the proportional limit, the machine reads a force...
-
11.12 Water, oil, and an unknown fluid are contained in the open vertical tubes shown in Fig. P11.12. Determine the den- sity of the unknown fluid. 1-in. diameter Oil, SG = 0.9 1 ft 1 I Water Figure...
-
A parallel circuit has a load made up from a resistance of 4092 and an inductive reactance of 2592, and is connected to an a.c. 50Hz supply. Calculate the voltage required to give an output power of...
-
0.3 m 12 rad/s 0.6 m C. 30 Based on the above figure, locate the location of instantaneous Center (IC) of zero velocity. a. Point A b. Point B Point O O d. None of the mentioned Clear my choice OB
-
Solve the equation. Write the solution set with the exact solutions. 5 log (7w+1)+3 = 13 If there is more than one solution, separate the answers with commas. There is no solution, {}. The exact...
-
The Ranch 888 Noodle Company sells two types of dried noodles:ramen, at $6.50 per box, and chow fun, at $7.70 per box. So farthis year, the company has sold a total of 110,096 boxes ofnoodles,...
-
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...
-
Consider a scenario where your laptop has stopped working and you take it to a repair center. The vendor asks for a huge sum of money, but you negotiate with him the price for repair. Create a class...
-
Consider a scenario where you negotiate with a company over the salary and perks being offered for a position. Create a class diagram for this using negotiation patterns as your base and draw a...
-
Consider a scenario where an online trade application is being developed. The two registered users can negotiate over the price of a product being traded. Create a class diagram for this application...
Study smarter with the SolutionInn App