Question
Generic Motors Corporation has two product lines, A and B. Its contribution margin statement for last year is as follows: Product A Product B Total
Generic Motors Corporation has two product lines, A and B. Its contribution margin statement for last year is as follows:
Product A | Product B | Total | |
sales volume (units) | 50 | 100 | 150 |
Revenue | $3,000 | $15,000 | $18,000 |
Variable costs: | |||
direct materials | $600 | $3,000 | $3,600 |
direct labor | $1,500 | $6,000 | $7,500 |
Contribution margin | $900 | $6,000 | $6,900 |
Fixed costs | $5,850 | ||
Profit | $1,050 |
Generic Motors uses ABC to allocate the fixed costs. It examined the main activities in the firm, and decided to break up the total fixed costs of $5,850into 3 cost pools:
* "labor-related" - the total cost in this pool is $1,500, allocated based on direct labor dollars
* "sales-related" - the total cost in this pool is $1,350, allocated based on number of units
* "production setups" - the total cost in this pool is $3,000, allocated based on the number of production batches. A is produced in batches of 10 units, and B is produced in batches of 5 units.
Required:
a) for each cost pool, compute the allocation rate and the amounts allocated to product A and product B. (assume that practical capacity = total activity volume for each pool)
(hint: The amounts allocated to A and B from each pool should add up to the total cost in that pool. To allocate the costs in the "production setups" pool, you will have to compute the number of batches. If the total number of batches for A and B does not add up to25, you are doing something wrong).
* "labor-related" pool:
allocation rate = $per DL$
FC allocated to A = $
FC allocated to B = $
* "sales-related" pool:
allocation rate = $per unit
FC allocated to A = $
FC allocated to B = $
* "production setups" pool:
allocation rate = $per batch
FC allocated to A = $
FC allocated to B = $
b) using the allocated costs from (a), compute the profit margin for product A and product B.
If you get a negative number, enter it with a minus sign, i.e., enter negative $100 as -100, not ($100)
profit margin for A = $
profit margin for B = $
2./5 points Ask Your Teacher My Notes
Question Part |
Points |
Submissions Used |
Question 2(evaluating customer profitability)
You own a credit card company. You want to evaluate the profitability of two representative customers, A and B. The numbers for customers A and B are as follows:
customer A | customer B | |
credit card balance | $1,000 | $400 |
number of transactions | 100 | 40 |
number of customer-support calls | 40 | 2 |
Your revenues and costs for customers are as follows:
* Revenues: The only source of revenue is the interest you charge on credit card balances. You charge customers an interest rate of20% (20% APR). So, if the credit card balance is $100, your revenue is $100*0.2=$20.
* Costs: based on the estimates from your ABC system, each transaction costs you $0.5, and each customer-support call costs you $4. Ignore all other costs.
Required:
a) compute the revenue you get from each customer, and the costs of serving each customer.
customer A | customer B | |
Revenue | $ | $ |
Cost of transactions | $ | $ |
Cost of customer-support calls | $ | $ |
b) compute the profit margin for each customer.
If you get a negative number, enter it with a minus sign, i.e., enter negative $200 as -200 not ($200)
profit margin for A = $
profit margin for B = $
c) if you solved (a) and (b) correctly, one of the customers should be unprofitable. What should you do about this customer?
Question 1.(production budget)The following table presents Generic Motors Company's production budget. GM's inventory policy is to have ending inventory equal to15% of next month's sales.
February | March | April | |
Ending inventory | 5,000 | ||
Beginning inventory | 4,500 | ||
Budgeted sales | 8,000 | 15,000 | 19,000 |
Budgeted production |
Score:0.66 out of 0.66
Comment:
2./5 points Ask Your Teacher My NotesQuestion Part |
Points |
Submissions Used |
Month | Sales revenue |
August | $110,000 |
September | $100,000 |
October | $100,000 |
November | $150,000 |
December | $145,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started