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