A company produces athletic shoes. For simplicity we assume that every month has 20 working days....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company produces athletic shoes. For simplicity we assume that every month has 20 working days. Each day consists of 7 hours of regular time and each employee can work up to 3 hours of overtime per day. As of today the company employs 100 workers who are paid a fixed monthly salary of $1000 dollars. The firm pays $10 per overtime hour. Hiring a worker costs $400; firing a worker costs $3000. Every worker can assemble 2 shoes per hour. The holding cost is $1.35 per unit per quarter. A penalty cost of $100 per unit is incurred on lost sales. Firm wants to ellaborate a production schedule for the next 10 quarters as to meet all demand each quarter. Formulate then solve (use excel solver) a linear program aimed at minimizing the total cost for the firm. The solution should include for each quarter the number of workers hired/fired, the number of overtime hours, the number of shoes produced, and the quantity of inventory. In addition, it must specify the total hiring cost, total firing cost, total inventory cost, total fixed salary cost, total cost on lost sales (if any), total overtime cost and total cost of the plan for the whole planning horizon. Year Remaining of last year 2 Initial workforce Fixed monthly salary Overtime cost Holding cost Quarter Hiring cost Firing cost 3 4 1 2 3 4 1 2 3 4 Production per worker Stock-out cost Working Days 20 60 60 60 60 60 60 60 60 60 Forecast Demand (units) $1,000.00 2982 43489 96217 65036 16119 89764 187090 120211 28524 152952 100 workers $10.00 per hour $1.35 per unit per quarter $400.00 $3,000.00 2 units per hour $100.00 per unit per quarter A company produces athletic shoes. For simplicity we assume that every month has 20 working days. Each day consists of 7 hours of regular time and each employee can work up to 3 hours of overtime per day. As of today the company employs 100 workers who are paid a fixed monthly salary of $1000 dollars. The firm pays $10 per overtime hour. Hiring a worker costs $400; firing a worker costs $3000. Every worker can assemble 2 shoes per hour. The holding cost is $1.35 per unit per quarter. A penalty cost of $100 per unit is incurred on lost sales. Firm wants to ellaborate a production schedule for the next 10 quarters as to meet all demand each quarter. Formulate then solve (use excel solver) a linear program aimed at minimizing the total cost for the firm. The solution should include for each quarter the number of workers hired/fired, the number of overtime hours, the number of shoes produced, and the quantity of inventory. In addition, it must specify the total hiring cost, total firing cost, total inventory cost, total fixed salary cost, total cost on lost sales (if any), total overtime cost and total cost of the plan for the whole planning horizon. Year Remaining of last year 2 Initial workforce Fixed monthly salary Overtime cost Holding cost Quarter Hiring cost Firing cost 3 4 1 2 3 4 1 2 3 4 Production per worker Stock-out cost Working Days 20 60 60 60 60 60 60 60 60 60 Forecast Demand (units) $1,000.00 2982 43489 96217 65036 16119 89764 187090 120211 28524 152952 100 workers $10.00 per hour $1.35 per unit per quarter $400.00 $3,000.00 2 units per hour $100.00 per unit per quarter
Expert Answer:
Answer rating: 100% (QA)
The following is a linear program that can be used to minimize the total c... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Jack can work up to 8 hours a day at a wage rate of W and as much more as he wants at the higher overtime rate of W. He chooses to work 10 hours. Jill can work as many hours as she wants at a wage of...
-
A firm has a monthly production function where L is hours of labor per month and K is square feet of manufacturing space. The marginal product of labor is The marginal product of capital is a. If the...
-
A production facility employs 10 workers on the day shift, 8 workers on the swing shift, and 6 workers on the graveyard shift. A quality control consultant is to select 5 of these workers for...
-
Evaluate the stiffness matrix for the elements shown in Figure P11-6. Let E = 100 GPa and v = 0.3? Figure P11-6, (a) (b) (25, 25.0) 2 (10, 0, 0) (40, 0,0) (25, 0, 25) (10, 7, 0) (4, 2, 0) (12, 2, 0)...
-
The accounting records of Americo Electronics show the following data. Beginning inventory 3,000 units at ....... $5 Purchases 8,000 units at .......... $7 Sales 9,400 units at ..............$10...
-
The unadjusted trial balance of World Enterprises for the year ended December 31, 2024, follows: Additional information: 1. There is $750 of supplies on hand on December 31, 2024. 2. The one-year...
-
An orthotropic AS/3501 carbon/epoxy lamina (see Tables 2.2 and 4.1) is subjected to the plane stress condition \(\sigma_{x}=1000 \mathrm{MPa}, \sigma_{y}=50 \mathrm{MPa}\), and \(\tau_{x y}=50...
-
Getaway Camps, Inc., leases the land on which it builds camp sites. Getaway is considering opening a new site on land that requires $3,000 of rental payment per month. The variable cost of providing...
-
A:Write a research proposal based on one of the following topics: 1: Social Media is positively or negatively affecting the way we communicate. 2: Cellphones should or should not be allowed in the...
-
Categorize each of the following characteristics as being more representative of either traditional manufacturing or lean production. 1. Quality tends to be inspected-in rather than built-in. 2....
-
Two companies bid on a project. The project work could be apportioned to the two companies. Company A has the following profit function P = P(A,B)XA-C and PB = P(XA, X)XBCB where A, B are the units...
-
The present value of an infinite stream of dollar payments of \(\$ z\) (that starts next year) is \(\$ z / i\) when the nominal interest rate, \(i\), is constant. This formula gives the price of a...
-
Comparing the recessions of 2000 and 2008. One very easy to use source of data is the FRED database. The series that measures real GDP is GDPC1, real GDP in each quarter of the year expressed at a...
-
IBM has long been one of the worlds foremost information technology enterprises, with a storied history of making information processing hardware and software and building a world-class business in...
-
Develop a P-H chart for saturated liquid and vapor butane in the range T = [260, 340] using the Peng-Robinson equation. Show constant S lines emanating from saturated vapor at 260 K, 300 K, and 340...
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. Except for promissory notes, the injured party in a contract may bring suit whenever he or...
-
to value her inventory items and would like to know how much money she is making on each product. Your task is to compute the standard inventory cost and gross profit margin for four of her top...
-
Study the pictures/images below. Obviously these was focus on LT sociology, anthropology and poltical science. Try to do some analysis by finding clues that are synonymous with the main concepts....
-
How would the wage rate and the level of employment be affected by the invention of a costless pill that made it unnecessary for anyone to sleep?
-
Suppose that there are exactly three factors of production: skilled labor, which is represented by unions; unskilled labor, which is not represented by unions; and capital. Currently, skilled labor...
-
Filbert is indifferent between baskets (3, 2) and (4, 1). Lychee is indifferent between baskets (1, 4) and (2, 3). Note that all four baskets lie along a straight line. a. Can you determine whether...
-
Consider the multiple linear regression model fit to the baseball data in Problem 3.41. Problem 3.41 Consider the 2016 major league baseball data in Table B.22. While team ERA was useful in...
-
Consider the simple linear regression model fit to the rental price data from Problem 2.36. Data From Problem 2.36 Table B.24 contains data on median family home rental price and other data for 51 US...
-
Consider the multiple linear regression model fit to the rental price data in Problem 3.42. Problem 3.42 Table B.24 contains data on median family home rental price and other data for 51 US cities....
Study smarter with the SolutionInn App