Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 13QP
a)
Summary Introduction
To formulate: An linear programming model for the problem.
b)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
c)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Material Handling Systems
Case
Mfa Company operates a centrally located storeroom in their manufacturing complex. Every afternoon, each craft foreman (Tin Shop, Electric Shop, Iron Workers, etc.) writes a requisition for common use items include nuts, bolts, screws, washers, flashlight batteries, and gloves. All specialty items are ordered separately.
During the night shift, the storeroom personnel fill the orders items requested by the craft foreman. Each morning, one or two workers from each department to go the storeroom with a four –wheel platform truck to pick up the filled order.
Question:
Although studies have been performed to determine the amount of time craftsmen spend waiting the supplies, it is the thoughts of the management that idle craft manpower is a problem resulting from this procedure. How can time spent traveling and from the described storeroom be reduced, thus, eliminating or decreasing crafts’ personnel travel time?
Workshape Manufacturing has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors purchase the same product. The customer activities and costs for the previous quarter are as follows:
Activity
JIT distributors
Non-JIT distributors
Sales Orders
500
30
Sales Calls
30
30
Service Calls
200
90
Average Order Size
90
1,400
Manufacturing Cost/Unit
$50
$50
Customer Costs:
Processing Sales Orders
$160,000
Selling Goods
$155,000
Servicing Goods
$195,000
Total
$500,000
Calculate the activity rate for selling goods. (Note: Round answer to two decimal places.)
a.$2,200.50 per sales call
b.$9,400.60 per sales call
c.$3,550.66 per sales call
d.$2,583.33 per sales call
e.$4,800.40 per sales call
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)…
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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
- HARDA Limited employs 650 workers in ten different departments. These workers work in various capacities, including the manufacturing workers, technician, and janitorial workers. Each department has a supervisor who is responsible for supervising departmental activities. In addition to supervising operations, the supervisors of the departments are responsible for recruiting, hiring, and firing workers within their areas of responsibility. The organization attracts casual labour and experiences a 20 to 30 per cent turnover rate in employees per year. Employees clock on and off the job each day to record their attendance on timecards. Each department has its clock machine located in an unattended room away from the main production area. Each week, the supervisors gather the timecards, review them for accuracy, and sign and submit them to the payroll department for processing. Besides, the supervisors submit personnel action forms to reflect newly hired and terminated employees. From…arrow_forwardStar Garage Limited provides motor vehicle accessories and services for a wide range of vehicles in Dominica. Customers purchase parts to take to their individual mechanics to complete vehicle repairs or they may choose to bring their vehicles to Star Garage for in-house repairs and servicing. This means that they pay for both the parts and the labour associated with the type of service required. Some services do not include any new parts, just the labour costs for that service. Individual customers must pay for all parts purchases in full at the time of sale. Individual customers must pay 50% down when they bring their vehicles in for servicing and pay the balance when they come to pick them up when the job is completed. Corporate customers, however, are billed monthly for all sales (parts or service). Although Star Garage Limited has several different banking accounts, all sales are deposited intact into its main chequing account. Star Garage Limited purchases its inventory of parts…arrow_forwardSarasota Go Karts (SGK) is a firm that manufactures racing go-karts (fictitious) in Sarasota Florida. They produce a low-volume, premium product used by those who race go-karts. In total, they produce and sell around 300 go-karts per year. They offer five different models, although some further customization can be added upon request. They sell their products directly to the consumer, who can visit their small showroom at their manufacturing plant if they are in the area. However, the majority of go-kart orders are placed via their website or the phone, and are then shipped to the customer. Over the years, SGK has ran into a number of problems. First is their inventory levels. Their finished goods inventory is substantial, at any one time they have between 250-300 finished go-karts on hand. This is because they want to have an inventory of all five go-kart models on hand at any point in time, and they produce each model in a batch of 50 units at a time. They also have substantial work…arrow_forward
- Use the following information to answer the question(s) below. Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. The machining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are shown in the spreadsheet below. D E F 11 2 3 A Cerebro Manufacturing Model 6 17 8 Product 14 Gross margin/unit Minutes/unit 15 Gross margin/minute Maximum production Profit B O 125,000 O 250,000 O None of the above C Machine Rivets Clips Capacity (mins./year) Plugs Rails $0.40 $ 1.20 $0.80 $1.10 13 1.5 250,000 Assuming that one half of the machine capacity is used for the production of plugs. What is the maximum possible production of plugs based on this capacity? O 166,666.67 83,333.33arrow_forwardFutura Company purchases the 79,000 starters that it installs in its standard line of farm tractors from a supplier for the price of $12.60 per unit. Due to a reduction in output, the company now has idle capacity that could be used to produce the starters rather than buying them from an outside supplier. However, the company’s chief engineer is opposed to making the starters because the production cost per unit is $13.30 as shown below: Per Unit Total Direct materials $ 6.00 Direct labor 3.20 Supervision 1.90 $ 150,100 Depreciation 1.20 $ 94,800 Variable manufacturing overhead 0.40 Rent 0.60 $ 47,400 Total product cost $ 13.30 If Futura decides to make the starters, a supervisor would have to be hired (at a salary of $150,100) to oversee production. However, the company has sufficient idle tools and machinery such that no new equipment would have to be purchased. The rent charge above is based on space utilized in the plant. The total rent on the plant…arrow_forwardNSZH corporation has two branches located in two different cities. Branch-1 has staff of 14 workers who are working 7 hours per day, incurring payroll cost of $950 per day, producing 10 titles per day, incurring overheads of $600 per day. Branch-2 has staff of 12 workers who are working 8 hours per day, incurring payroll cost of $840 per day, producing 12 titles per day, incurring overheads of $850 per day. Calculate that which branch has higher labor productivity and which branch has higher multifactor factor productivity of the two branches of NSZH corporation.arrow_forward
- The ABC Corporation has been engaged in the manufacture of electronic components for automobiles for the last five years. The company employees 350 employees and about 30 supervisors and managers. The increase in technology requires that employees be sent to cope with the increasing demand for updated new products consistent with the demand of local and foreign customers. The HR Manager suggested that three of the managers and eight supervisors be sent to the mother company in Japan for updates in technology on car electronics. The Vice President for Finance and the Operation Manager opposed the recommendation on the basis of cost-cutting and lack of personnel to handle the operations while they were asway for two months. They suggested that technicians from the mother company be invited instead to handle the training in the Philippines. The cost of training by the mother company would double the cost of training as they are paid higher allowances and salaries that will be charged to…arrow_forwardPort Ormond Carpet Company manufactures carpets. Fiber is placed in process in the Spinning Department, where it is spun into yarn. The output of the Spinning Department is transferred to the Tufting Department, where carpet backing is added at the beginning of the process and the process is completed. On January 1, Port Ormond Carpet Company had the following inventories: Finished Goods $8,200 Work in Process-Spinning Department 1,800 Work in Process-Tufting Department 2,900 Materials 4,800 Departmental accounts are maintained for factory overhead, and both have zero balances on January 1. Manufacturing operations for January are summarized as follows: Jan. 1 Materials purchased on account, $82,700 2 Materials requisitioned for use: Fiber-Spinning Department, $43,800 Carpet backing-Tufting Department, $34,900 Indirect materials-Spinning Department, $3,200 Indirect materials-Tufting Department, $2,800 31 Labor used: Direct…arrow_forwardAs part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem-solving costs $8,000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost.b. Graph the feasible…arrow_forward
- Joint Products The Bean Company provides fresh coffee beans for restaurants, hotels, and otherfood service companies. Bean offers three types of coffee beans: Premium, Gourmet, and Quality.Each of the three coffees is produced in a joint process in which beans are cleaned and sorted. Thesorting process is the split-off point in this joint process, and the output is the three types of beans.The beans can be sold at the split-off point or processed further, with different types of roastingand additional sorting. The additional processing requires additional, separable processing costs, asshown next. Separable processing requires no special facilities, and the production costs of furtherprocessing are entirely variable and traceable to the products involved. Last year all three productswere processed beyond split-off. Joint production costs for the year were $90,000,000. Sales valuesand costs needed to evaluate Bean’s production policy follow:Premium Gourmet Quality TotalPounds produced…arrow_forwardKala 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_forwardZucchero Sugar, Inc. has six processing departments for refining sugar—Affination, Carbonation, Decolorization, Boiling, Recovery, and Packaging. Conversion costs are added evenly throughout each process. Data from the month of August for the Recovery Department are as follows: Metric Tons Beginning Work−in−Process Inventory 0 Transferred in 22,000 Ending Work−in−Process Inventory 6,000 Costs Beginning Work−in−Process Inventory $0 Costs added during August : Direct materials 530,000 Direct labor 250,000 Manufacturing overhead 105,000 Total costs added during August $885,000 The ending Work−in−Process Inventory is 100% and 95% complete with respect to direct materials and conversion costs, respectively. The weighted−average method is used. How many metric tons of sugar were refined and transferred to the Packaging Department in August? A. 6,000 metric tons B.…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,