The company is expected to have a cash balance of 65,000 on January 1, 2021. The company wants to maintain a minimum cash balance of $15,000. Loan and interest payments are made in multiples of 10,000 in the earliest quarter in which there is sufficient cash (that is, when the cash on hand exceeds the $15,000 minimum required balance). Prepare a 1.labour and 2.manufacturing overhead budget

The company is expected to have a cash balance of 65,000 on January 1, 2021. The company wants to maintain a minimum cash balance of $15,000. Loan and interest payments are made in multiples of 10,000 in the earliest quarter in which there is sufficient cash (that is, when the cash on hand exceeds the $15,000 minimum required balance). Prepare a 1.labour and 2.manufacturing overhead budget

Name: The company is expected to have a cash balance of 65,000 on January 1,
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: The company is expected to have a cash balance of 65,000 on January 1, 2021. The company wants to maintain a minimum cash balance of $15,000. Loan and interest payments are made in multiples of 10,000 in the earliest quarter in which there is suffici

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 133P

See similar textbooks

Similar questions

The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
Although the company estimated that they will end with 400 units, the actual inventory on hand at the end of June was 350 units. The company doesn’t want to maintain a minimum target inventory. Due to challenges with recruiting process, they want to minimize labor and capacity costs. The rate to maintain inventory at end of each period per month is a holding cost of $1.5 per unit, and the company would like to have 600 units on hand at the end of December. Each unit requires five employee hours to produce, there are 22 working days each month and each employee works eight hours per day. Each employee produces 35.2 units per month. The work force at the end of June was 35 employees. On average, each employee is paid $2,800 per month. Based on the effort of interviewing and training new employees, the company estimates that it costs $2,000 for each employee hired. Firing pays amounts to $2,000 per employee. Determine a level production plan that minimizes arbitrary hiring and firing…
A company is preparing an aggregate production plan for its product for the next four months. The company's expected monthly demand is given in the following table. The company will have 100 million in inventory at the beginning of this month and wishes to hold at least 100 Units at the end of each month.Important data is shown below: production cost per unit =$125 cost of inventory storage per month per unit =$10 cost of hiring per worker =$50 firing cost per worker =$100 initial number of workers =25 each worker can produce =25 units per month Month->expected demand: M1 ->600 M2->800 M3->700 M4->900 What is the total cost of a chase plan that uses only hiring/firing?
The state firefighters’ association has a membership of 15,000. The purpose of the organization is to provide some financial support to the families of deceased member firefighters and to organize a conference each year bringing together firefighters from all over the state. Annually, members are billed dues and calls. “Calls” are additional funds required to take care of payments made to the families of deceased members. The bookkeeping work for the association is handled by the elected treasurer, Bob Smith, although it is widely known that his wife, Laura, does all of the work. Bob runs unopposed each year at the election, since no one wants to take over the tedious and time consuming job of tracking memberships. Bob is paid a stipend of $8000 per year, but his wife spends well over 20 hours per week on the job. The organization, however, is not happy with their performance. A computer system is used to track the billing and receipt of funds. This system was developed in 1984 by a…
The Westerbeck Company manufactures several models of automatic washers and dryers. The projected requirements over the next year for their washers are shown in the table below: Month & Requirement January - 710 February - 1090 March - 880 April - 690 May - 1400 June - 1130 July - 1550 August - 1020 September - 530 October - 390 November - 980 December - 1210 Current inventory is 140 units. Current capacity is 1,030 units per month. The average salary of production workers is $1,150 per month. Material costs $140/unit. Each production worker accounts for 35 units per month. Overtime is paid at time and a half. Any increase or decrease in the production rate costs $40/unit for tooling, setup, and line changes. This does not apply, however, to overtime. Inventory-holding costs are $30 per unit per month. Lost sales are valued at $70 per unit. Compare the costs of level and chase demand production plans using the Agg Plan – Level and Agg Plan – Chase…
Nice-Fit is a (fictional) small business producing outfits for costume parties and specialoccasions. Custom designs can be tailored to a customer’s request. Tom and Ann are theowners of the company and source all the fabric, design the outfits and make the costumesthemselves. Tom and Ann keep spreadsheets with information on the material purchased andcostumes made, but they find it difficult to keep track of their products, raw materials, andsales. The raw materials are supplied from a fabric company in India, and the production takesplace in a manufacturing company in China. The clothing is sold at local weekend markets,sold, or rented through costume hire shops, and sold at their physical store. Tom and Annreceive a small percentage of the sales and rentals of their costumes from the hire shops.They have no information on customers other than those who request custom designsdirectly from them. In 2020, the Covid-19 pandemic had a major impact on global economies,businesses and how we…
RMC, Inc., is a small firm that produces a variety of chemical products. In a particular production process, three raw materials are blended (mixed together) to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 25 ton of material 1 and 35 of material 3. A ton of solvent base is a mixture of 12 ton of material 1, 15 ton of material 2, and 310 ton of material 3. After deducting relevant costs, the profit contribution is $40 for every ton of fuel additive produced and $30 for every ton of solvent base produced. RMC’s production is constrained by a limited availability of the three raw materials. For the current production period, RMC has available the following quantities of each raw material: RAW MATERIAL Amount Available for Production Material 1 20 Tons Material 2 5…
Wallace Company makes and sells a single product. Each unit of product requires two hours of labor with a wage rate of $8 per hour. The company has budgeted to sell 8,000 units and to produce 10,000 units during the current month. The product requires three pounds of material for each unit produced. Budgeted direct labor costs for the current month would be: $192,000 $128,000 $80,000 $64,000 $160,000
A carpenter produces chairs, tables, and windows. The following information is provided: Cost of production per unit of chairs, tables, and windows is 2, 4, and 6 respectively, and can be sold at 7, 10, and 12, respectively. Weekly demand on chairs, tables, and windows is expected to not exceed 400, 200, and 100, respectively. Production of the three products requires wood, metal sheets and paint. The following table shows the unit requirement of each of the three materials needed and the availability of each. Chairs Tables Windows Weekly availability Wood 2 3 7 1000 Metal Sheets 1 - 1 400 Paint 3 5 10 2000 Production of tables may not exceed twice the units produced of chairs. Total production budget is expected to be 10,000 Pounds every week. Formulate the linear programming model to determine the number of units to produce of the three products such that the net profit is maximized.