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

Required: (a) Fill in the missing numbers in the table above. (Hint if you get stuck: What is the relation between ending inventory for one month and beginning inventory for the following month?) b) Why do firms want to hold inventory of finished goods? (an alternative could be to produce exactly the amount they are going to sell, and hold zero inventories)

Score:0.66 out of 0.66

Comment:

2./5 points Ask Your Teacher My Notes

Question Part

Points

Submissions Used

Question 2.(cash receipts from sales) Budgeted sales revenue for the coming five months is as follows:

Month	Sales revenue
August	$110,000
September	$100,000
October	$100,000
November	$150,000
December	$145,000

You estimate that you will collect35% of sales revenue in the month of sale,35% in the following month,20% two months after the sale, and the remaining10% three months after the sale. Required: a) Compute budgeted cash inflows for November and December. November = $ December = $ (Hint: pay attention to the timing, e.g. "35% is collected in the following month" means35% of August revenue is collected in September, i.e., cash receipts (inflows) for September include35% ofpreviousmonth's sales revenue.) b) Is it possible for a firm to run out of cash even though it is profitable? If no, explain why not, if yes, give an example of how that can happen