Shivani founded a company that specializes in hànd-crafted wooden fürniture. She is planning to devote their production capacity this week to producing up to three different products: a dining table, a dining chair, and a sleigh bed. The machine-hours required for each unit of the respective products, along with the available capacity of the machines, are summarized in the table below. The unit profits would be $250, $100, and $350 for the table, chair, and bed, respectively. How many of each product should Shivani produce so as to maximize profits? Build a linear programming spreadsheet model, and solve it using Solver. Machine-Hours Required per Unit Dining Table Dining Chair Available Time Sleigh Bed (machine-hours per week) 1575 Milling Machine Lathe 3 2 3 2000 Grinder 2 900
Q: Using the diagram, find: The critical path. How long it will take to complete the project? How does ...
A: A network diagram is a visual representation of a project which helps to identify the activity relat...
Q: Consider a product that is stocked using periodic review inventory policy. Orders are placed every 2...
A: Find the Given details below: Given details: Lead time 4 days Review time 21 days Mean 58 U...
Q: The condition of nonnegativity requires that: a. the objective function cannot be less than zero ...
A: Linear programming is widely used technique to find the optimal decisions based on certain given par...
Q: (a) Calculate the order quantity and reorder point. (b) Determine the annual holding and ordering co...
A: Holding cost is the cost incurred during the holding, storing and managing of the inventory stock in...
Q: Sinclair Plastics operates two chemical plants which produce polyethylene; the Ohio Valley plant whi...
A: Find the Given details below: Given details: Manufacturing Plants Plant Grand Rapids Blue...
Q: After a successful newspaper business, Jimmy plans to expand by opening an icrecream shop, only if t...
A: The Expected Value (EV) indicates the weighted average of conveyed alternatives; to compute this mul...
Q: a.Determine two-sigma control limits using the above data. (Round your intermediate calculations to ...
A: WE WILL USE AN X-BAR CHART. UCL=X ¯+2X¯LCL=X ¯-2X¯
Q: Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three week and a four-week ...
A: Forecasting helps in predicting the future sales in advance so that there is no overstocking or unde...
Q: What are the characteristics of a project? (List 2 characteristics)
A: Project management is the procedure that guides the team to achieve all project goals within the giv...
Q: 3
A: Let T, R, and N be the number of ads in TV, radio, and newspaper respectively. Objective function: ...
Q: Examine globalisation as a flexible mode of organization that Amazon may employ.
A: The term globalisation can be understood as expansion of trade activities globally and involving in ...
Q: Electrocomp’s management realizes that it forgot to include two critical constraints (see Problem 7-...
A: A slack or surplus worth is reported for every one of the constraints. The expression "slack" applie...
Q: Why is it so critical to avoid data-entry mistakes on an e-commerce website?
A: Data entry nowadays has become a significant sep in order to streamline databases, however, errors i...
Q: Define conceptualizations?
A: In this part, we'll look at conception, which is one of the first steps in the measurement process. ...
Q: What exactly is modular design? What are its key benefits and drawbacks?
A: A modular design is a product design method that is used to create a full product by integrating or ...
Q: Three employees at a fast-food restaurant each perform one of the three activities in serving a cust...
A:
Q: Assignment problems are LPP problems where a project/work is assigned to a specific machine or to an...
A: Given data is
Q: I Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three- week and a four-we...
A: Forecasting the future demand/sales can be done by various methods like moving average, weighted mov...
Q: Which of the following document best ensures that the proper quantities are reflected on supplier in...
A: Packaging slip is a document that include information like SKU numbers, weights, dimensions and numb...
Q: Consider the LP problem in Figure QP2.5 and refer to the Solver sensitivity report in Figure QP2.6. ...
A: Given- Sensitivity analysis report-
Q: a. Using linear regression analysis, what would you estimate demand to be for each month next year? ...
A: The demand can be computed for each month can be computed using linear regression analysis.
Q: A Northeast Airline gate agent, Chip Gilliken, gives out seat assignments to ticketed passengers. He...
A: The normal time (NT) is calculated by multiplying the mean observed time by the performance rating f...
Q: MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis. Special d...
A: An entity-relationship diagram (ERD), otherwise called an entity-relationship model, is a graphical ...
Q: 4. How many human resource needs to be determined?5. What are the possible sources of applicants for...
A: ANSWER (4) Any organization's intended output will need a deliberate deployment of human resources a...
Q: The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of powe...
A: Seasonal index = season demand / average yearly demand Seasonal index when multiple periods are gi...
Q: 3 reasons for a company to acquire another company
A: There are number of possible reasons which might motivate a company to acquire or merge with another...
Q: explain how containers or cards are used in kanban system
A: The word kanban has a Japanese origin which means to signal. This system is basically used to trigge...
Q: You are managing a business that design products for specific medical purposes. Your potential deman...
A:
Q: The following table shows the result of a survey about the industry that students hope to work in a...
A:
Q: All of the following are characteristics of a project EXCEPT: Select one: a. Has a defined beginnin...
A: A project can be stated as the sequence or series of activities that must be accomplished to attain ...
Q: 4 - Smithson Cutting is opening a new line of scissors for supermarket distribution. It estimates it...
A: The Break-even point is the point where the total production cost and total production revenue are e...
Q: A recent report on executive awareness of and involvement in corporate pandemic preparedness by Mich...
A: Not exclusively are HR experts worried about employees' wellbeing and prosperity during the pandemic...
Q: You purchased a mechanical keyboard for P45 and plan to resell it for P63. What would the markup rat...
A: The mark up is the percentage of profit. It is calculated on 1. Cost 2. Sales Markup on cost = Pro...
Q: You are a marketing manager for a food products company, considering the introduction of a new brand...
A: Find the Given details below: Given details: Low Demand High Demand Gradual 1 4 Concentra...
Q: What is the trade-off between operator-performed maintenanceversus supplier-performed maintenance?
A: A trade-off can be stated as the conditional decision that includes decreasing or losing one standar...
Q: Given problem: A contractor has a job which should be completed in 120 days. At present, he has 80 ...
A: Given- Current workers = 80 workersEstimated completion time by the current workers = 150 daysReq...
Q: A data entry clerk entered the incorrect part number for a blender. The part number was the part num...
A: A validity check is an interaction of guaranteeing that an idea or development is adequate with rega...
Q: At a hydrocarbon processing factory, process control involves periodic analysis of samples for a cer...
A: Given Sample data-
Q: Consider the following MRP record for a notebook manufacturer. COVER 3 4 5 6 Gross requirements 20 2...
A: Material requirements planning (MRP) can be defined as a computer-based framework intended to furth...
Q: The EOQ for a particular model of laptops at “Computer Giants” is 40 units and the annual demand is ...
A: Given data Annual demand (D) = 2000 units Economic Order Quantity (EOQ) = 40 units Cost at the t...
Q: pleqse solve the question 2 here using the information in question 1
A: as per your instruction, we are solving the second question. given,
Q: Why is trust so important in effective SCM? How would you measure the performance of a supply chain?
A: A supply chain is a channel between a business & its suppliers to make & distribute particul...
Q: What are the traditional measures for meeting customer needs? What are the major limitations to thes...
A: Customer needs can be defined as the motivational and psychological factors that would trigger a cus...
Q: what are the factors to consider When selecting a facility location? customer proximity business e...
A: The correct option is (d) - all of the above There are different kinds of factors which are to be t...
Q: Which European institution is responsible for proposing EU legislation, implementing it, and monitor...
A: Note- Hi! Thank you for the question As per the honour code, We’ll answer the first question since t...
Q: Ohio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia...
A:
Q: What does a supply chain mean? What is the relationship between the supply chain and operations mana...
A: Production is the process of transforming the raw inputs into finished products and services for the...
Q: The success of any operation relies on the leader who is in charge of the operations management. Wha...
A: Here is no question that the effective leader contributes instantly to the business & operation'...
Q: For the Toy Car table above, what are the Planned Order Receipts in the week of 8/31? For the Toy Ca...
A: Instructions and formula used: Net requirements = Gross requirements - previous period Project...
Q: Rock View Restaurant is a new fast food restaurant chain. The Operations Manager has divided its nor...
A: Find the Given details below: Given details: Task Time(Sec) A 25 B 20 C 35 D 32 E 25 ...
Please solve using excel solver
Step by step
Solved in 2 steps with 4 images
- A manager must decide which type of machine to buy, A, B, or C. Machines costs are as follows: Machine Cost A $40,000 B $30,000 C $80,000 Product forecast, processing times on the machines, and setup times are as follows: Processing Time Per Unit (minutes) Product Annual Demand A B C Setup Times (minutes) Production Lots (units) 1 16,000 3 4 2 20 200 2 12,000 4 5 3 35 100 3 6,000 5 6 3 60 50 4 30,000 2 4 1 15 500 Machines operate 10 hours a day, 250 days a year. The manager wants to have a capacity cushion of 10%. a. Assume that only purchasing costs are being considered. Which machines would have the lowest total cost, and how many of that machines would be needed? b. Consider this additional information: The machines differ in terms of hourly operating costs: The A machines have an hourly operating cost of $11 each, B machines have an hourly operating cost of $10 each, and C machines have an hourly operating cost of $12 each. Which alternative would…4. The Spencer Optics Company produces an inexpensive line of sunglasses. The manufacturing process consists of assembling two plastic lenses (produced by the firm's plastic molding depart- ment) into a finished frame (purchased from an outside supplier). The company is interested in using material requirements planning to schedule its operations and has asked you to prepare an example to illustrate the technique. The firm's sales manager has prepared a 10-week sales forecast for one of the more popular sunglasses (the Classic model) for your example. The forecast is 100 units per week. Spencer has customer orders of 110 units, 80 units, 50 units, and 20 units in weeks 1, 2, 3, and 4, respectively. The sunglasses are assembled in batches of 300 units. Presently, three such batches are sched- uled: one in week 2, one in week 5, and one in week 8. Complete the following time-phased record: Week hand 1 2 3 4 5 6 7 8 9 10 Classic Model On MPS Record Forecast Orders Projected available…QuestionByron Sports is a manufacturer of sportswear. It produces all of its products in one department using a process costing system.The information for the current month is as follows:Beginning work in process (30% complete as to conversion cost) 12,000 unitsUnits started 90,000 unitsUnits completed and transferred out ?Ending work in process (70% complete as to conversion) 8,000 unitsCosts:Beginning work-in-process direct materials $28,800Beginning work-in-process conversion $5,040Direct materials added during month $216,000Conversion costs incurred during the month $139,200Direct materials are added at the beginning of the process. Conversion costs are incurred uniformlythroughout the production process. Costing is handled on a FIFO basis Required:a. Prepare a production cost worksheet using 5 steps approach.b. Under what conditions would a process costing system be more appropriate than a job order costing system? Explain.
- Macon Controls produces three different types of controlunits used to protect industrial equipment from overheating Each of these units must be processed by a machine thatMacon considers to be their process bottleneck. The plantoperates on two 8-hour shifts, 5 days per week, 52 weeks peryear. Table 4.2 provides the time standards at the bottleneck,lot sizes, and demand forecasts for the three units. Becauseof demand uncertainties, the operations manager obtainedthree demand forecasts (pessimistic, expected, and optimis-tic). The manager believes that a 20 percent capacity cushionis best.a. How many machines are required to meet minimum(pessimistic) demand, expected demand, and maximum(optimistic) demand?b. How many machines are required if the operations man-ager decides to double lot sizes? c. If the operations manager has three machines and be-lieves that the plant can reduce setup time by 20 percentthrough process improvement initiatives, does that planthave adequate capacity to…Tax Prep Advisers, Inc., has forecasted the following staffingrequirements for tax preparation associates over the next12 months. Management would like three alternative staffingplans to be developed. The company currently has 10 associates. No more than 10new hires can be accommodated in any month because oflimited training facilities. No backorders are allowed, andovertime cannot exceed 25 percent of regular-time capacityon any month. There is no cost for unused overtime capac-ity. Regular-time wages are $1,500 per month, and overtimewages are 150 percent of regular-time wages. Undertime ispaid at the same rate as regular time. The hiring cost is $2,500per person, and the layoff cost is $2.000 per person.a. Prepare a staffing plan utilizing a level workforce strategy,minimizing undertime. The plan may call for a one-timeadjustment of the workforce before month 1.b. Using a chase strategy, prepare a plan that is consistent withthe constraint on hiring and minimizes use of overtime.c.…Climate Control, Inc., makes expedition-quality rain gearfor outdoor enthusiasts. Management prepared a forecast ofsales (in suits) for next year and now must prepare a produc-tion plan. The company has traditionally maintained a levelworkforce strategy. All nine workers are treated like familyand have been employed by the company for a number ofyears. Each employee can produce 2,000 suits per month.At present, finished goods inventory holds 24,000 suits. Thedemand forecast follows: Use the Sales and Operations Planning with SpreadsheetsSolver in OM Explorer or develop your own spreadsheetmodels to address the following questions. a. Management is willing to authorize overtime in pe-riods for which regular production and current lev-els of anticipation inventory do not satisfy demand.However, overtime must be strictly limited to no morethan 20 percent of regular-time capacity. Managementwants to avoid stockouts and backorders and is notwilling to accept a plan that calls for shortages.…
- IIn a job shop, effective capacity is only 69 percent of design capacity, and actual output is 76 percent of effective output. What design capacity would be needed to achieve an actual output of 13 jobs per week? What is its effective capacity? a. The Design Capacity needed to achieve the required actual job outputs =Blank 1 (round to whole number) b. The Effective Capacity needed to achieve the required actual job outputs = Blank 2 (round to whole number) Blank 1 Blank 2 Add your answer Add your answerA recruiter for a job placement agency is considering whether to pay $50,000 per year to lease a new recruiting facility in a prime location in Washington D. C. He estimates it will cost $50 per recruit to process the paperwork at this new location. He receives a $75 commission for each new recruit he processes. Part A - If the office space at this new location has design and effective capacities of 10,000 and 8,000 recruits processed annually, respectively, and 6,000 recruits will be processed per year, what will be the utilization of the office space?Part B - If his office space at this new location has design and effective capacities of 10,000 and 8,000 recruits processed annually, respectively, and he plans to be 90% efficient in his use of this space, how many recruits does he plan to process per year?Average and Total Costs The Accounting Club wants to have a party for its members. The costof renting space is $1,500, and the cost of refreshments will be $15 per person.Required1. What is the total cost if 100 people attend? What is the average cost?2. What is the total cost if 200 people attend? What is the average cost?3. Explain why average total cost differs with changes in total attendance.
- In the bakery, we have established that design capacity is 30 pies per day and effective capacity is 20 pies per day. Currently, the bakery is producing 27 pies per day. What is the bakery’s capacity utilization relative to effective capacity?William Beebe owns a small shoe store. He has 10 pairs of shoes that requireresoling and polishing. He has a machine that can resole one pair of shoes at atime, and the time required for the operation varies with the type and condition of theshoe and the type of sole that is used. Shoes are polished on a machine dedi-cated tothis purpose as well, and polishing is always done after resoling. His assistant generally does the polishing while Mr. Beebe does the resoling. The resoling and polishingtimes (in minutes) are Shoes Resoling Time Polishing Time1 14 32 28 13 12 24 6 55 10 106 14 67 4 128 25 89 15 510 10 5In what order should the shoes be repaired in order to minimize the total makespanfor these 10 jobs?1. Power Notebooks, Inc. plans to manufacture a new line of notebook computers. Management is trying to decide whether to purchase the LCD screens for the computers from an outside supplier or to manufacture the screens in-house. The screens cost $100 each from the outside supplier. To set up the assembly process required to produce the screens in-house would cost $100,000. The company could then produce each screen for $75. The number of notebooks that eventually will be produced (Q) is unknown at this point. a. Set up a spreadsheet that will display the total cost of both options for any value of Q. Use trial-and-error with the spreadsheet to determine the range of production volumes for which each alternative is best. b. Use a graphical procedure to determine the break-even point for Q (i.e., the quantity at which both options yield the same cost). 2. Back Savers is a company that produces backpacks primarily for students. They are considering offering some combination of two…