Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Will’s Welded Widgets (WWW) makes its Q Model from components R, S, and T. Component R is made from 2 units of component X and 2 unit of component Y. Component T is made from 1 unit of component V and 2 units of component Z.
Calculate the gross requirements for each of the components when the company plans to build 70 of its Q Model if you have these inventories: 70 units of component T and 110 units of component R, using the given information:
Item
Usage per Parent
Q
-
R
2
S
2
T
1
X
2
Y
2
V
1
Z
2
Q
R S T
X Y V Z
Put the answers down into the table: (If answer is zero, please enter 0, do not leave any fields blank.)
Product
Gross Requirements
Q…
Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and
the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB
produced in Stage 2 are required for each unit of Product XC in Stage 3.
Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below:
Stage 2
Stage 1
11
No overtime
No
subcontracting
No sales
0.07
Unit regular time cost (TL)
Unit overtime cost (TL)
Unit subcontracting cost (TL)
Unit selling price (TL)
Unit processing time (hrs)…
A mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large
pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible
to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130
volume units? If so, how many each type of pellet should be in the mixture?
Pellet Type
5.
Number of
Cost per Pellet in
Cents
Weight
Units per Pellet
Volume
Pellets
Units per Pellet
Regular
Large
Extra large
2
1
4
y
1
4
3
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Kala is one of the top manufacturer of ukuleles. The manufacturer produces three different types of ukuleles. Its Concert produce $6 in profit per unit; its Soprano produce $4 in profit per unit; and its Tenor produce $8 in profit per unit. Each type of ukulele passes through three manufacturing stages as a part of the entire production process. The three process centers of modelling, curing and assembly has an available production time per day of 12 hours, 14 hours and 16 hours, respectively. To produce one hundred units of Concert, the time required for the process of modelling, curing and assembly is 2 hours, 3 hours and 2 hours, respectively. To produce one hundred units of Soprano, 2 hours of modelling, 2 hours of curing and 1 hour of assembly is required. Whereas 4 hours of modelling, 2 hours of curing and 2 hours of assembly is required to produce one hundred units of Tenor. Sensitivity report of the problem is given as below where C = unit of Concert to be produced each day, S…arrow_forwardCan you please fill out the main boxes in a way that can be easily deciphered??arrow_forwardCrane Corporation manufactures a single product. Monthly production costs incurred in the manufacturing process are shown below for the production of 3800 units. The utilities and maintenance are mixed costs. The fixed portions of theses costs are 430 and 270, respectively. Production In Units 3800 Production Costs Direct Materials 7904 Direct Labor 15124 Utilities 1798 Property Taxes 1180 Indirect Labor 4484 Supervisory salaries 2100 Maintenance 1182 Depreciation 2650 Calculate the expected costs when product is 5,300 unitsarrow_forward
- This question refers to the stress-strain curve shown above. What is the yield stress? 39GPa 200GPa 1500MPa. 1950MPaarrow_forwardXYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?arrow_forwardThe sales forecast for a certain product being sold at P300/bundle is P25M/month. Each bundle has 100 packs with a weight of 30grams/pack. The product undergoes the following manufacturing processes: PROCESS CAPACITY/UNIT COST/UNIT EFFICIENCY Kneading 200kg/hr P800,000 85% Cutting 60kg/hr 600,000 90 Drying 500kg/hr 1,200,000 100 Seasoning 75kg/hr 100,000 100 Packaging 2,400packs/hr 250,000 95 If the company is operating at 25 days/month @ 24-hour operation, how much money is needed for the procurement of the machines? How many factory workers are needed in a 2-shift operation if kneading requires 2 operators, cutting - 2, drying - 1, seasoning - 1 and packaging - 3?arrow_forward
- Comfort-Air produces 3 types (Type 1, Type 2 and Type 3) thermostats for household temperature control. Three limited resources are required for the production. These resources are available time (R1) of a Robotic Insertion Machine (RIM), workforce hours (R2) and certain type of electronic components (R3). Profits generated from each unit of the thermostats are shown in the first row of the following table. The amount of resources required to produce one unit of the thermostats are also given in the table. The last column of the table shows the available amount of the resources. Comfort-Air needs to decide the numbers of thermostats of each type (x,,x, and x,) to produce in order to maximize its total profit. Table: Production Related Data Туре 2 115 Thermostat Туре 1 Туре 3 Available Amount of Profit per unit product Amount of required resources to produce each unit product 80 70 Resource 1840 (hour) 2100 (hour) 3500 (units) R1 5 8 7 R2 4 7 R3 8. 10 12 1) Based on the given…arrow_forwardIntroduction to Operations Researcharrow_forwardSleek Sdn. Bhd. is planning on introducing 2 new stool designs (Deni & Arni) for their 2022 furniture catalogue. Each stool is made up of 4 legs and 1 seat. Both designs use the same seat. Deni has shorter (1.5 foot) legs, while Arni has longer (2.5 foot) legs. It takes 0.1 hours of labour to cut and shape a short leg, 0.15 hours to do the same for a long leg, and 0.5 hours to produce a seat. It takes an additional 0.3 hours to attach a set of legs to a seat for either design. The estimated profit is RM25 for each Deni sold and RM45 for each Arni sold. Sleek has unlimited access to material for seats, but only has 500 feet of material for the legs, and 75 labour hours available. Formulate a Linear Program for Sleek Sdn. Bhd. that optimises profit. Assume that Sleek is able to sell all stools that they make and that they must have zero leftover legs and seats.arrow_forward
- 33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…arrow_forwardSales representatives sell two products A and B. Based on historical data there is an average 20 euro commission for every call on product A and a 10 euro commission for every call on product B. Data also shows that sales representatives spend about 3 hours per call for product A and 2 hour for product B. The company requires at least 25 calls per month for each product and not more than 100 calls per month on any one product. How should the sales representatives allocate their monthly 165 working hours between making calls selling products A and B if they want to maximize their commission? a) Mathematically formulate the LP model for maximizing commissions (=primal problem) b) Mathematically formulate the dual problem of the primal problem. Implement both LP models (primal and dual) using Excel Solver. c) Report the optimal objective functions, decision variable values and the shadow prices of both the primal and dual problems. d) Confirm that these numbers are in line with…arrow_forward4) The making of rivet holes in structural steel members can be done by 2 methods. The first method consists of laying out the position of the holes in the members and using a drill press costing P100k. The machinist is paid P60 per hour and he can drill 80 holes per hour. The second method makes use of a multiple-punch machine costing P80k. The punch operator is paid P40 an hour and he can punch out 1 hole for 3 seconds. This method also requires an expense of P1.25 per hole to set the machine. (a) if all other costs are assumed equal, what is the total cost for each machine for 10k holes, assuming the total cost of each machine to be charged to these holes? (b) for how many holes will the costs be equal?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,