Question

In: Accounting

Q. Edmonds has a product that has the following budgeted amounts for January. Sales Price $200,...

Q. Edmonds has a product that has the following budgeted amounts for January. Sales Price $200, Variable Manufacturing Cost $100, Commission (10% of sales) $20, Contribution Margin $80, Fixed costs $240,000, Maximum Capacity 5,000 units, Expected sales in January 4,500 units. They are approached about a special order for 500 units at $125. The sales commission would be a flat $500 and no other customer would be affected.

1) What is the expected income without the special order?

2) What is the effect of special order on the income?

3) Now suppose the order is for 600 units and is all or nothing.
What is the economic effect if they accept the new order?

Solutions

Expert Solution

1. Calculation of expected income without the special order:

Number of units to be sold = 4500

Contribution margin per unit = $80

Total Contribution = $360000

less: Fixed cost = $240000

Net Income = $ 120000

2. Effect of special order on net income:

Total Revenue = 125*500 = $62500

Less: Variable cost = 500*100 =$50000

Less: Sales Commission=$500

Net Income = $ 12000

The net Income would increase from the special order by $12000. No additional fixed costs would be incurred & no loss of contribution would arise from 4500 units since there is sufficient spare capacity for an order of 500 units.

3. Since the order is for 600 units & there is spare capacity for only 500 units, there would be loss of contribution from existing 100 units also.

Effect of special order on Net Income:

Total revenue = 600*125 = $75000

Less:variable costs = 600*100= $60000

Less: Sales Commission = $500

Less: Loss of contribution = 100*80 =$8000

Net Income = $6500

If the order for 600 units is accepted, then the net income will rise by $6500 .


Related Solutions

Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January...
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January 80,000 February 90,000 March 120,000 April 150,000 May 180,000 June 120,000 Eunice Ltd. sells a single product at a price of $60 per unit. There were 18,000 units of finished goods in inventory at the beginning of February. Eunice Ltd.’s policy is to keep the inventory of finished goods equal to 20% of the unit sales for the next month. Three kilograms of materials...
2. Jo-Jo’s Yo-yos has the following budgeted sales and direct materials purchases: Month Budgeted Sales Budgeted...
2. Jo-Jo’s Yo-yos has the following budgeted sales and direct materials purchases: Month Budgeted Sales Budgeted direct materials purchases January $190,000 $30,000 February $210,000 $35,000 March $300,000 $45,000 Jo-Jo’s Yo-yos’ sales are 40% cash and 60% on credit. It collects credit sales 10% in the month of the sale, 50% in the month following the sale, and 36% in the second month following the sale. 4% of the sales are uncollectible. Jo-Jo’s Yo-yos’ purchases are 50% cash and 50% on...
Eckert Company has budgeted the following unit sales:
Eckert Company has budgeted the following unit sales: 2016                             Units                                     April                            25,000                                     May                            50,000                                     June                           75,000                                     July                            45,000 Of the units budgeted, 40% are sold by the Southern Division at an average price of $15 per unit and the remainder are sold by the Eastern Division at an average price of $12 per unit. Instructions Prepare separate sales budgets for each division and for the company in total for the second quarter of 2017 by completing the chart. Do NOT...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 3,700 units Past experience has shown that the ending finished goods inventory for each month should be equal to 25% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 7,300 units Past experience has shown that the ending finished goods inventory for each month should be equal to 20% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...
The following information pertains to the January operating budget for Casey Corporation.         ∙       Budgeted sales...
The following information pertains to the January operating budget for Casey Corporation.         ∙       Budgeted sales for January $200,000 and February $107,000.         ∙       Collections for sales are 40% in the month of sale and 60% the next month.         ∙       Gross margin is 25% of sales.         ∙       Administrative costs are $11,000 each month.         ∙       Beginning accounts receivable is $26,000.         ∙       Beginning inventory is $15,000.         ∙       Beginning accounts payable is $68,000. (All from inventory purchases.)        ...
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900, 11,400, 11,900, and 13,400 units, respectively. The ending finished goods inventory equals 20% of the following month's sales. The ending raw materials inventory equals 40% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. If 61,000 pounds of raw materials are required for production in March, then the budgeted raw material purchases for February...
Wyatt Company has budgeted the following units sales for 2011: January 10,000 units February 8,000 units...
Wyatt Company has budgeted the following units sales for 2011: January 10,000 units February 8,000 units March 9,000 units April 11,000 units May 15,000 units Data regarding Finished Goods and Raw Materials Inventory is as follows: FINISHED GOODS: The finished goods units on hand on December 31, 2010 was 2,000 units. Each unit required 2 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods...
Kristopher Company has budgeted sales of $300,000 with the following budgeted costs:       Direct materials                    &nb
Kristopher Company has budgeted sales of $300,000 with the following budgeted costs:       Direct materials                                       $60,000       Direct manufacturing labor                       40,000       Factory overhead             Variable                                               30,000             Fixed                                                    50,000       Selling and administrative expenses             Variable                                               20,000             Fixed                                                    30,000       Required (10 points):             Compute the average markup percentage for setting prices as a percentage of:                         The full cost of the product The variable cost of the product Variable manufacturing costs Total manufacturing costs
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT