Complete the templates selling price

Assignment Help Accounting Basics
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

Reference no: EM13852795

Questions Cloud

What is the profitability index? : The current value of Australian Galaxy Cruises is $10,987,654. The initial book value of Pacific Dream is $37 million.
Calculate the average per capita gdp growth rate : In 1980, per capita GDP of Rwanda was about $728 and in 2010 about $1,025. Calculate the average per capita GDP growth rate of Rwanda from 1980 to 2010.
Calculate romanias population level : If the population of Romania was about 22 million in 2010 and the average population growth rate is 0.2 percent, then calculate Romania’s population level in 1970.
Average inflation rate : Between 1970 and 1976, average inflation rate of Country X was about 35 percent per year. With that rate of inflation, prices would double about every ________ using the rule of 70.
Complete the templates selling price : Complete the templates Selling price & GM - Markup and Revenue, COGS, GM template.
Is the market currently over or under producing this good : Suppose that demand for a product is Q = 1000 – P and supply is Q = 9P. Furthermore, suppose that the marginal external damage of this product is $20 per unit. Suppose this is a negative production externality. Calculate the Q currently being produce..
Prepare the journal entry to amortize patent at year end : Tandem Industries purchased a patent on January 1, 2014, for $2,000,000. The patent's legal life is 20 years but the company estimates that the patent's useful life will only be 5 years from the date of acquisition. Seminole Partners purchased a fran..
Development of a strategic plan for a business : Is strategic planning as important for a small company as for a large company? Why or why not? How would you approach the development of a strategic plan for a business you own
Derive an expression for average cost : Derive an expression for average cost. Derive an expression for marginal costs. Is there any range of production characterized by scale of economies? At what production level are scale economies exhausted?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd