Business, 15.07.2021 06:10 kotzdude

The Columbia Manufacturing Company’s sales manager has produced the following sales forecast for next year and the production manager has provided additional information listed below.
Product Family Q1 Q2 Q3 Q4
A 250 350 500 125
B 150 225 360 75
Product Family A:
• Two direct labor hours per unit of product
• Setup cost equals $700 if the product is produced in a quarter
• Setup time equals eight direct labor hours
• Inventory carrying cost per quarter equals $1.50 per one direct labor hour of work left in
inventory at the end of the quarter
• Materials cost equals $70 per direct labor hour of production
• Beginning inventory is zero units
Product Family B:
• One direct labor hour per unit of product
• Setup cost equals $600 if the product is produced in a quarter
• Setup time equals ten direct labor hours
• Inventory carrying cost per quarter equals $1 per one direct labor hour of work left in inventory at
the end of the quarter
• Materials cost equals $50 per direct labor hour of production
• Beginning inventory is zero units
Additional Factors:
• Hiring cost per employee equals $1,500
• Firing cost per employee equals $500
• Overtime cost per direct labor hour equals $15
• Regular time cost per direct labor hour equals $10
• The maximum number of regular time hours to be worked per employee per quarter equals 520
• Employees may not work more than 25% of the regular time hours on overtime each quarter
• The company currently has 2 manufacturing workers at the beginning of quarter 1.
Formulate and solve a mixed-integer program to generate a production plan that minimizes the total cost over
the next year

Answers: 3

Show answers

Other questions on the subject: Business

Business, 21.06.2019 19:50, elijahbebeastin

One investigating company tracked all credit card purchase during 2012 and measured two variables: (1) the type of credit card used (visa, mastercard, american express, or discover), and (2) the amount (in dollars) of each purchase. identify the level of each variable measured.

Answers: 1

continue

Business, 22.06.2019 06:40, jordenv00

Self-interest achieve society’s economic goals because producers know which goods consumers want the most. as consumers and producers exercise their freedom to act in their own self-interest, markets will produce the desired goods at the lowest possible cost. consumers and producers both operate based on society’s economic goals. consumers know which goods can be produced at the lowest cost. there is a wide variety of desired goods and services in a market system because producers determine what to produce. consumers change their minds frequently. there is always a need to produce something new and improved. individual wants are diverse. what is produced is ultimately determined by consumers, because if the goods offered are not what consumers want, consumers will not buy them. producers, because they are driven by profits. producers, because they determine what to produce. consumers, because they participate in marketing surveys.

Answers: 2

continue

Business, 22.06.2019 06:40, haleyturkey

Depreciation on the company's equipment for 2017 is computed to be $18,000.the prepaid insurance account had a $6,000 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of the company's insurance policies showed that $1,100 of unexpired insurance coverage remains. the office supplies account had a $700 debit balance on december 31, 2016; and $3,480 of office supplies were purchased during the year. the december 31, 2017, physical count showed $300 of supplies available. two-thirds of the work related to $15,000 of cash received in advance was performed this period. the prepaid insurance account had a $6,800 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of insurance policies showed that $5,800 of coverage had expired. wage expenses of $3,200 have been incurred but are not paid as of december 31, 2017.

Answers: 3

continue

Business, 22.06.2019 09:00, aghalyaa

Harry is 25 years old with a 1.55 rating factor for his auto insurance. if his annual base premium is $1,012, what is his total premium? $1,568.60 $2,530 $1,582.55 $1,842.25

Answers: 3

continue

You know the right answer?

The Columbia Manufacturing Company’s sales manager has produced the following sales forecast for nex...