subject
Business, 13.08.2021 01:00 kyle65

How would you solve set this question up to use solver? A manufacturer of motorcycle accessories wants to optimize the production schedule for its best-selling motorcycle stand. Below are relevant inputs:
2% of each month's new sales (anticipated new sales) will be returned for a refund (for a reason other than a defect). Assume that these returns will happen in the following month, and that in the month after that, the product can be sold as an "open-box" product. The company assesses holding costs on all items held in stock from month-to-month. This also applies to returns. The cost of holding products is always based on the current month's production cost, even if some of the products being held are returns from the previous month. The company assigns a 5% of monthly production cost to each item held in inventory between months.
All demand from anticipated sales must be met on time and production capacity cannot be exceeded. Configure and run solver to find a production schedule that optimizes total costs.
Initial inventory 50
Holding cost as % of prod. cost 5%
Returned Products 2%
Month 1 2 3 4 5 6
Production Cost/Unit $95 $105 $100 $80 $75 $95
Production Capacity 540 600 420 420 455 600
Anticipated new sales 400 450 550 600 400 350

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 11:00
How did the contribution of the goods producing sector to gdp growth change between 2010 and 2011 a. it fell by 0.3%. b. it fell by 2.3%. c. it rose by 2.3%. d. it rose by 0.6%. the answer is b
Answers: 1
question
Business, 22.06.2019 11:40
Zachary company produces commercial gardening equipment. since production is highly automated, the company allocates its overhead costs to product lines using activity-based costing. the costs and cost drivers associated with the four overhead activity cost pools follow: activities unit level batch level product level facility level cost $ 64,800 $ 27,730 $ 15,000 $ 154,000 cost driver 2,400 labor hrs. 47 setups percentage of use 11,000 units production of 780 sets of cutting shears, one of the company’s 20 products, took 240 labor hours and 7 setups and consumed 15 percent of the product-sustaining activities. required: (a) had the company used labor hours as a company wide allocation base, how much overhead would it have allocated to the cutting shears? (b) how much overhead is allocated to the cutting shears using activity-based costing? (c) compute the overhead cost per unit for cutting shears first using activity-based costing and then using direct labor hours for allocation if 780 units are produced. if direct product costs are $150 and the product is priced at 30 percent above cost for what price would the product sell under each allocation system? (d) assuming that activity-based costing provides a more accurate estimate of cost, indicate whether the cutting shears would be over- or underpriced if direct labor hours are used as an allocation base. explain how over-or undercosting can affect vaulker's profitability. (e) comment on the validity of using the allocated facility-level cost in the pricing decision. should other costs be considered in a cost- plus pricing decision? if so, which ones? what costs would you include if you were trying to decide whether to accept a special order?
Answers: 1
question
Business, 22.06.2019 13:10
Lin corporation has a single product whose selling price is $136 per unit and whose variable expense is $68 per unit. the company’s monthly fixed expense is $32,400. required: 1. calculate the unit sales needed to attain a target profit of $5,000. (do not round intermediate calculations.) 2. calculate the dollar sales needed to attain a target profit of $8,400.
Answers: 3
question
Business, 22.06.2019 18:00
Which of the following is a characteristic that can be used to guide the design of service systems? a. services cannot be inventoried. b. services are all similar. c. quality work means quality service. d. services businesses are inherently entrepreneurial. e. even service businesses have internal services.
Answers: 2
You know the right answer?
How would you solve set this question up to use solver? A manufacturer of motorcycle accessories wa...
Questions
question
History, 17.04.2020 23:06
question
Mathematics, 17.04.2020 23:06
question
Mathematics, 17.04.2020 23:07
Questions on the website: 13722362