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
- Structure Furniture, manufactures coffee tables. Structure Furniture has a policy of adding a 20% markup to full costs and currently has excess capacity. The following information pertains to the company's normal operations per month: Output units Machine-hours 30,000tables 8,000hours Direct manufacturing labour-hours 10,000hours Direct materials per unit Direct manufacturing labour per hour Variable manufacturing overhead costs Fixed manufacturing overhead costs Product and process design costs Marketing and distribution costs S100 S12 $322,500 $1,200,000 $900,000 $1,125,000 a) Structure Furniture is approached by an overseas customer to fulfill a one-time-only special order for 1,000 units. All cost relationships remain the same except for a one-time setup charge of $20,000. No additional design, marketing, or distribution costs will be incurred. What is the minimum acceptable bid per unit on this one-time-only special order? b) What is the Structure Furniture full product cost for…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 $8000. 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 costarrow_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 $8000.  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.  Graph the feasible region.…arrow_forward
- 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 time cards. Each department has its clock machine located in an unattended room away from the main production area. Each week, the supervisors gather the time cards, 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_forwardHARDA 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 time cards. Each department has its clock machine located in an unattended room away from the main production area. Each week, the supervisors gather the time cards, 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_forwardHARDA 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_forward
- Star 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_forwardGunes Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 800 units. The costs and percentage completion of these units in beginning inventory were: Cost PercentCompleteMaterials costs $ 10,600 65% Conversion costs $ 12,800 30% A total of 8,500 units were started and 7,400 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department during the month: CostMaterials costs $ 142,100 Conversion costs $ 359,500 The ending inventory was 50% complete with respect to materials and 35% complete with respect to conversion costs.  The cost per equivalent unit for conversion costs for the first department for the month is closest to:$44.58$46.16$40.03$48.47arrow_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_forwardDigital Controis, Inc. (DCI), manufactures two models of a radar gun used by police to monitor the speed of automobiles. Model A has an accuracy of plus or minus 1 mile per hour, whereas the smaller model B has an accuracy of plus or minus 3 miles per hour. For the next week, the company has orders for 100 units of model A and 150 units of model B. Although DCI purchases all the electronic components used in both models, the plastic cases for both models are manufactured at a DCI plant in Newark, New Jersey. Each model A case requires 4 minutes of injection-molding time and 6 minutes of assembly time. Each model B case requires 3 minutes of injection-molding time and 8 minutes of assembly time. For next week, the Newark plant has 600 minutes of injection-molding time avallable and 1,080 minutes of assembly time availab The manufacturing cost is $10 per case for model A and $6 per case for model B. Depending upon demand and the time avalable at the Newark plant, DCI occasionally…arrow_forwardThe 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_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,