Textile Mill Scheduling Problem formulation • Variable assignment on the length of each fabric produced and purchased: X1 - Length of fabric 1 in Yards produced as dobbie looms X2 - Length of fabric 2 in Yards produced as dobbie looms X3 - Length of fabric 3 in Yards produced as dobbie looms X4 - Length of fabric 4 in Yards produced as dobbie looms X5 - Length of fabric 5 in Yards produced as dobbie looms X6 - Length of fabric 3 in Yards produced as regular looms X7 - Length of fabric 4 in Yards produced as regular looms X8 - Length of fabric 5 in Yards produced as regular looms X9 - Length of fabric 1 in Yards purchased X10 - Length of fabric 2 in Yards purchased X11 - Length of fabric 3 in Yards purchased X12 - Length of fabric 4 in Yards purchased X13 - Length of fabric 5 in Yards purchased • Monthly Data for Scottsville Textile Mill Fabrics Fabric 1 Fabric 2 Fabric 3 Fabric 4 Fabric 5 Demand, D 16,500 22,000 62,000 7,500 62,000 Selling Price, S 0.99 0.86 1.1 1.24 0.7 Variable Cost, V 0.66 0.55 0.49 0.51 0.5 Purchase price, P 0.8 0.7 0.6 0.7 0.7 • Cost Fabric Manufacturing cost (Selling Price- Variable Cost) Purchasing Cost (Selling price- Purchase Price) 1 0.99-0.66= 0.33 0.99-0.8= 0.19 2 0.86-0.55= 0.31 0.86-0.7= 0.16 3 1.1-0.49= 0.61 1.1-0.6= 0.5 4 1.24-0.51= 0.73 1.24-0.7= 0.54 5 0.7-0.5= 0.2 0.7-0.7= 0 • Working Hour in a Month Dobbie: 8 looms x 24 hours x 30 days= 5760 hours Regular: 30 looms x 24 hours x 30 days= 21600 hours • Yard per hour Fabric
* The variances are due to the Mile High Cycle company not forecasting for increased production. The company budgeted for the production of 10,000 cycles but the actual production was 10,800 units. When the company increased production, the production efficiency decreased. The company had to use or rework parts that added extra cost to the expenses; the reworked parts added $25,000 of extra expenses to the wheel assembly production and $45,000 to the final assembly process. The material,
Job J57 and Job K52 involve 15 acres of landscaped terrain which will require special-order sprinkler heads to meet the specifications of the project. Using a job cost system to produce these parts, the following events occurred during December 2012. Raw materials were requisitioned from the company’s inventory on December 2 for $5,061; on December 8 for $1,059; and on December 14 for $3,459. In each instance, twothirds (2/3) of these materials were for J57 and the rest for K52. Six time tickets were turned in for these two projects for a total amount of 18 hours of work. All the workers were paid $16.50 per hour. The time tickets were dated December 3, December 9, and December 15. On each of those days, 6 labor hours were spent on these jobs, two-thirds (2/3) for J57 and the rest for K52. The predetermined overhead rate is based on machine hours. The expected machine hour use for the year is 2,112 hours, and the anticipated overhead costs are $840,576 for the year. The machine were used by workers on projects K52 and J57 on December 3, 9, and 15. Six machine hours were used for project K52 (2 each day), and 8.5 machine hours were used for project J57 (2.5 the first day and 3 each of the other days). Both of these special orders were completed on December 15, producing 237 sprinkler heads for J57 and 142 sprinkler heads for K52. Additional job order
In January, Reyes Tool & Dye requisitions raw materials for production as follows: Job 1 $960, Job 2 $1,630, Job 3 $720, and general factory use $680. During January, time tickets show that the factory labor of $6,100 was used as follows: Job 1 $1,570, Job 2 $1,940 Job 3 $1,670, and general factory use $920. Prepare the job cost sheets for each of the three jobs. (If answer is zero, please enter 0, do not leave any fields blank.) Job 1 Date 1/31 1/31 Direct Materials 960 0 Job 2 Date 1/31 1/31 Direct Materials 1630 0 Job 3 Date 1/31 1/31 Direct Materials 720 0 0 1670 Direct Labor 0 1,940 Direct Labor 0 1570 Direct Labor
PROBLEM 2-24B Schedule of Cost of Goods Manufactured; Overhead Analysis (LO1, LO2, LO3, LO6, LO7)
The assignment method was used in determining ways that the schedule can be change to maximize production while reducing idle time, completion time, and potentially labor costs. Using the information that was provided, Operator A will cost $10.00 for the first job, $11.00 for the second, $9.00 for the third, and $10.00 for the fourth. Operator B will cost $12.00 for the first job, $9.00 for the second job, $8.00 for the third, and $8.00 for the fourth. Operator C similarly will cost $11.00 for the first, $11.00 for the second, $11.00 for the third, and $9.00 for the fourth. Last, Operator D will cost $11.00 for the first, $11.00 for the second, $9.00 for the third, and $10.00 for the fourth. While
In order to maximize the total profit, the monthly production plan should be 1900 unit/month for Model S and 650 unit/month
Irwin Textile Mills produces two types of cotton cloth denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 8 pounds of raw cotton per yard, whereas denim requires 6 pounds of raw cotton per yard. A yard of corduroy requires 4 hours of processing time; a yard od denim requires 3.0 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 510 yards per month. The manufacturer has 6,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $2.5 per yards of denim and $3.25 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. Formulate the model and put into standard form. Solve it
CRU Computer Rental Case Solutions Solution 1 TABLE 1: CRU FLOWS | Customer | Receiving | Status 24 | Status 40 | Stored Orders | Orders at Suppliers | Status 41 | Status 42 | Status 20 | | | | | | | | | | | Throughput(Units/Week) | 1000 | 1000 | 1000*.70=700 | 1000*.30+ .15 *700= 405 | 405 | 405 | 405 | 405 | 1000 | | | | | | | | | | | Inventory(Units) | 8000= 8*1000 | 500 | 1500 | 1000 | 500 | 405= 405*1 | 500+405 = 905 | 500 | 2000=2*1000 | | | | | | | | | | | Flow Time(Weeks) | 8 | 0.5= 500/1000 | 2.14= 1500/700 | 2.46=1000/405 | 1.23= 500/405 | 1 | 2.23 | 1.23= 500/405 | 2 | Note: Numbers in Black are given Numbers in red are calculated by using formula Av.
Reference Case from "Project Management, A Systems approach to planning, scheduling and controlling" by Harold Kerzner, PH.D.
When we schedule the orders for September in the above manner, the CNC machine gets the four largest orders and has run-time of 157 hours, whereas, the rest of the orders are executed on the manual machines which have run time of 160 hours each. Thus, we can process the entire set of orders with the bottleneck resources being busy for 160 hours each (in contrast with 196 hours of CNC taken in the case to service same set of orders).
The fixed overhead is forecast as R450 000. The fixed overhead cost rate is R5 per direct labour hour, calculated as R450 000/90 000 =
We have the given details like the objectives of making profit of $2.25 per yard for denim and $3.10 for yard of Corduroy and constraints of processing time of 3.2 hour for Corduroy and 3 for Denim, 6500 pounds of total cotton and 3000 hours of processing time and the demand is unlimited for Denim and 510 maximum for corduroy. By table above details,
With Forest Hill turning to an activity based costing system many things have become clearer. In the volume based system, costs were attributed to grades that did not belong. The slitting cost being
Superior Metals Company has seen its sales volume DECLINE over the last few years as the result of rising foreign imports. In order to INCREASE sales (and hopefully, profits), the firm is considering a price reduction on luranium, a metal that it produces and sells. The firm currently sells 60,000 kilos of luranium a year at an average price of $10 per kilo. Fixed costs of producing luranium are $250,000. Current variable costs per kilo are $5. The firm has determined that the variable cost per kilo could be reduced by $0.50 if production
The Jung Corporation's production budget calls for the following number of units to be produced each quarter for next year: