A4 Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the sameproduction equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demandforecast for the next four months, in hours required to make each product is:PRODUCTAPRILMAYJUNEA790590790JULY1,190B590690890с6904906901,090840Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is madeand carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A,$4 for B, and $5 for C.Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.The number of production hours available for regular time and overtime isRegular timeOvertimeAPRIL1,490MAY1,380690640JUNE1,790JULY2,000890940Calculate the objective value using Excel Solver. (Do not round intermediate calculations.)Objective value

The image you sent is a word problem about production planning at Alan Industries. They are…

Answered: Alan Industries is expanding its…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter10: Short-term Decision Making

Section: Chapter Questions

Problem 7PB: Remarkable Enterprises requires four units of part A for every unit of Al that it produces....

See similar textbooks

Similar questions

Midwest Industrial Products Corporation makes two products, Product H and Product L. Product H isexpected to sell 50,000 units next year and Product L is expected to sell 10,000 units. A unit of either product requires 0.2 direct labor-hours.The company’s total manufacturing overhead for the year is expected to be $1,920,000.Required:1. The company currently applies manufacturing overhead to products using direct labor-hours asthe allocation base. If this method is followed, how much overhead cost would be applied to eachproduct? Compute both the overhead cost per unit and the total amount of overhead cost that wouldbe applied to each product. (In other words, how much overhead cost is applied to a unit of ProductH? Product L? How much overhead cost is applied in total to all the units of Product H? Product L?)2. Management is considering an activity-based costing system and would like to know what impact thischange might have on product costs. For purposes of discussion, it has been…
Remarkable Enterprises requires four units of part A for every unit of Al that it produces. Currently, part A is made by Remarkable, with these per-unit costs in a month when 4,000 units were produced: Variable manufacturing overhead is applied at $1.60 per unit. The other $0.50 of overhead consists of allocated fixed costs. Remarkable will need 8,000 units of part A for the next years production. Altoona Corporation has offered to supply 8,000 units of part A at a price of $8.00 per unit. If Remarkable accepts the offer, all of the variable costs and $2,000 of the fixed costs will be avoided. Should Remarkable accept the offer from Altoona Corporation?
Gent Designs requires three units of part A for every unit of Al that it produces. Currently, part A is made by Gent, with these per-unit costs in a month when 4.000 units were produced: Variable manufacturing overhead is applied at $1.00 per unit. The other $0.30 of overhead consists of allocated fixed costs. Gent will need 6,000 units of part A for the next years production. Cory Corporation has offered to supply 6,000 units of part A at a price of $7.00 per unit. It Gent accepts the offer, all of the variable costs and $1,200 of the fixed costs will be avoided. Should Gent Designs accept the offer from Cory Corporation?
Bobcat uses a traditional cost system and estimates next years overhead will be $800.000, as driven by the estimated 25,000 direct labor hours. It manufactures three products and estimates the following costs: If the labor rate is $30 per hour, what is the per-unit cost of each product?
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: The shaper is available for 120 hours, and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1,000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are 8, 6, and 9, respectively. a. Formulate and solve for the recommended production quantities. b. What are the objective coefficient ranges for the three components? Interpret these ranges for company management. c. What are the right-hand-side ranges? Interpret these ranges for company management. d. If more time could be made available on the grinder, how much would it be worth? e. If more units of component 3 can be sold by reducing the sales price by 4, should the company reduce the price?
The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 mens and 125 womens models to be shipped during the first month and 200 mens and 150 womens models to be shipped during the second month. Additional data are as follows: Last month, the company used a total of 1,000 hours of labor. The companys labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. (Hint: Define variables for production and inventory held in each period for each product. Then use a constraint to define the relationship between these: inventory from end of previous period + produced this period demand this period = inventory at end of this period.) a. Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained and what are the monthly labor requirements? b. If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? How much will the cost increase? What would you recommend?
Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?
If a factory operates at 100% of capacity one month, 90% of capacity the next month, and 105% of capacity the next month, will a different cost per unit be charged to the work-in-process account each month for factory overhead assuming that a predetermined annual overhead rate is used?
The Calhoun Textile Mill is in the process of deciding on a production schedule. It wishes to know how to weave the various fabrics it will produce during the coming quarter. The sales department has continued orders for each of the 15 fabrics produced by Calhoun. These demands are given in the following table. Also given in this table is the variable cost for each fabric. The mill operates continuously during the quarter: 13 weeks, 7 days a week, and 24 hours a day. There are two types of looms: dobbie and regular. Dobbie looms can be used to make all fabrics and are the only looms that can weave certain fabrics, such as plaids. The rate of production for each fabric on each type of loom is also given in the table. Note that if the production rate is zero, the fabric cannot be woven on that type of loom. Also, if a fabric can be woven on each type of loom, then the production rates are equal. Calhoun has 90 regular looms and 15 dobbie looms. For this problem, assume that the time requirement to change over a loom from one fabric to another is negligible. Management would like to know how to allocate the looms to the fabrics and which fabrics to buy on the market so as to minimize the cost of meeting demand.
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year:
Please provide answer
The Rodgers Company makes 27,000 units of a certain component each year for use in one of its products. The cost per unit for the component at this level of activity is as follows: Direct materials. $4.20 Direct labor. $12.00 $5.80 Variable manufacturing overhead. Fixed manufacturing overhead $6.50 ****** Rodgers has received an offer from an outside supplier who is willing to provide 27,000 units of this component each year at a price of $25 per component. Assume that direct labor is a variable cost. None of the fixed manufacturing overhead would be avoidable if this component were purchased from the outside supplier. Assume that there is no other use for the capacity now being used to produce the component and the total fixed manufacturing overhead of the company would be unaffected by this decision. If Rodgers Company purchases the components rather than making them internally, what would be the impact on the company's annual net operating income? Select one: a. $94,500 increase b.…

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

SEE MORE TEXTBOOKS