Reference no: EM13852795

Please book following transactions, and ratios, and compute breakeven's

1 1-Mar Purchase _____inventory on account equal to 125% of projected sales @ cost

2 2-Jan Settle ____128,100 accounts payable

3 31-Mar Record rent expense

4 3-Mar Record ___revenue,______COGS for transaction is ____based on sales forecast

5 8-Mar Receive ______ 58,400.00 against accounts receivable

6 31-Mar Pay _______ 12,867.75 cash for marketing expense

7 31-Mar Pay________ 10,417.68 administrative expense in cash

8 31-Mar Pay _______ 18,270.0 cash for r & d expense

9 28-Feb Record _______ 300 supplies expense

10 31-Mar Book depreciation

11 31-Mar Record income tax expense on account at 0.35

12 31-Mar Settle income tax payable from previous month

13 31-Mar Make payment on note, record interest, amortization: Note 1

14 31-Mar Make payment on Note 2: Annual rate .09, interest accrued 1 month

Note increased by 1 month's interest prior to amortization over 24 months

15 31-Mar Make payment on Note 2: Annual rate .09, interest accrued 1 month on second note, record interest, amort.

16 Investments in Available for Sale Securities _______ 80,000.00 in cash

Securities worth ______ 79,400.00 at month end

17 31-Mar Dividend _______ 8000

1. U.S. Thunder Corp. is contemplating the following sales mix scenario for the next period.

Please complete the following templates:

a. Selling price & GM (.50)
b. Markup % (.50)
c. Revenue, COGS, GM template (1.0)

	Custom		Standard		Deluxe
Sell	364.00		450.00		663.00
Cost	260.00		300.00		340.00
GM	104.00		150.00		323.00
Cost +	1.4		1.55		1.95
Markup %
Units	110		165		139	414.00
Revenues	40,040.00		74,250.00		92,157.00	206,447.00
Costs	28,600.00		49,500.00		47,260.00	125,360.00
GM	11,440.00		24,750.00		44,897.00	81,087.00

If Thunder cuts its price by 12% on each item, how much of a volume increase will be needed to restore the
original profit level?		Use This For Sales and COGS
Volume % increase (1.0)
Template (2.0)
	Custom		Standard		Deluxe
Sell
Cost	260.00		300.00		340.00
GM	#VALUE!		#VALUE!		#VALUE!
Cost +
Markup %
Units						-
Revenues	#VALUE!		#VALUE!		#VALUE!	#VALUE!
Costs	#VALUE!		#VALUE!		#VALUE!	#VALUE!
GM	#VALUE!		#VALUE!		#VALUE!	#VALUE!

If Thunder increases its price by 10% on each item, how much of a volume decrease could it sustain before falling before the original profit level?

Volume % decrease (1.0)
Template (2.0)
	Custom		Standard		Deluxe
Sell
Cost	260.00		300.00		340.00
GM	#VALUE!		#VALUE!		#VALUE!
Cost +
Markup %
Units
Revenues	#VALUE!		#VALUE!		#VALUE!
Costs	#VALUE!		#VALUE!		#VALUE!
GM	#VALUE!		#VALUE!		#VALUE!

Attachment:- Accounting.xlsx