Question

PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :)

Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has no excess capacity, accepting this order means that only 11,000 cases of copy paper can be sold through normal channels.

1. How much profit (net income) will Parry Enterprises lose or gain if they this offer?

2. Assume Parry Enterprises has excess capacity of 3,000 cases. How much profit (net income would they lose or gain if they accepted the offer?

Hint: Create an income (profit and loss) statement showing Parry Enterprises normal course of business. To answer question 1, copy that income statement and then adjust it to show Parry Enterprises accomodating Texas Office Emporium's request. Compare the two statements to determine how much Parry Enterprises would lose or gain by accepting the offer. Repeat the process for question 2.

Answer 1

Income Statement
	Normal
Sales Revenue	$        5,25,000
Variable Costs	$        2,25,000
Contribution Margin	$        3,00,000
Operating Expenses	$           30,000
Net Operating Income	$        2,70,000

1.

Income Statement
	Normal	Accept Offer
Sales Revenue	$        5,25,000	$       4,85,000
Variable Costs	$        2,25,000	$       2,25,000
Contribution Margin	$        3,00,000	$       2,60,000
Operating Expenses	$           30,000	$          30,000
Net Operating Income	$        2,70,000	$      2,30,000

Enterprise loses $40000 i.e. 270000-230000

2.

Income Statement
	Normal	Accept Offer
Sales Revenue	$        5,25,000	$       5,90,000
Variable Costs	$        2,25,000	$       2,70,000
Contribution Margin	$        3,00,000	$       3,20,000
Operating Expenses	$           30,000	$          30,000
Net Operating Income	$        2,70,000	$      2,90,000

Enterprise wll gain $20000 i.e. 290000-270000