Homework Answers
| What if assumption | DATE - | 18-02-2020 | |||||||
| Bonus | 5.00% | ||||||||
| Commission | 3.25% | ||||||||
| Marketing | 9.00% | ||||||||
| Research and Development | 5.75% | ||||||||
| Support, General and Administrative | 17.00% | ||||||||
| Campus clothiers | |||||||||
| Semiannual Projected Gross Margin, Expenses and Operting Income | |||||||||
| January | February | March | April | May | June | Total | Spark Line | Columns | |
| Sales | 33,83,909.82 | 68,80,576.15 | 97,42,702.37 | - | 45,66,722.63 | 85,27,504.39 | 3,31,01,415.36 | ||
| Cost of Goods Sold | 13,19,724.83 | 26,83,424.70 | 37,99,653.92 | - | 17,81,021.83 | 33,25,726.71 | 1,29,09,551.99 | ||
| Gross Margin | 20,64,184.99 | 41,97,151.45 | 59,43,048.45 | - | 27,85,700.80 | 52,01,777.68 | 2,01,91,863.37 | ||
| Expenses | |||||||||
| Bonus | 1,69,195.49 | 3,44,028.81 | 4,87,135.12 | - | 2,28,336.13 | 4,26,375.22 | 16,55,070.77 | ||
| Commission | 1,09,977.07 | 2,23,618.72 | 3,16,637.83 | - | 1,48,418.49 | 2,77,143.89 | 10,75,796.00 | ||
| Marketing | 3,04,551.88 | 6,19,251.85 | 8,76,843.21 | - | 4,11,005.04 | 7,67,475.40 | 29,79,127.38 | ||
| Research and Development | 1,94,574.81 | 3,95,633.13 | 5,60,205.39 | 3,00,000.00 | 2,62,586.55 | 4,90,331.50 | 22,03,331.38 | ||
| Support, General and Administrative | 5,75,264.67 | 11,69,697.95 | 16,56,259.40 | 8,50,000.00 | 7,76,342.85 | 14,49,675.75 | 64,77,240.61 | ||
| Total Expenses | 13,53,563.93 | 27,52,230.46 | 38,97,080.95 | 11,50,000.00 | 18,26,689.05 | 34,11,001.76 | 1,43,90,566.14 | ||
| Operating Income | 7,10,621.06 | 14,44,920.99 | 20,45,967.50 | -11,50,000.00 | 9,59,011.75 | 17,90,775.92 | 58,01,297.23 |
| What if assumption | DATE - | 18-02-2020 | |||||||
| Bonus | 5.00% | ||||||||
| Commission | 3.25% | ||||||||
| Marketing | 9.00% | ||||||||
| Research and Development | 5.75% | ||||||||
| Support, General and Administrative | 17.00% | ||||||||
| Campus clothiers | |||||||||
| Semiannual Projected Gross Margin, Expenses and Operting Income | |||||||||
| January | February | March | April | May | June | Total | Spark Line | Columns | |
| Sales | 33,83,909.82 | 68,80,576.15 | 97,42,702.37 | - | 45,66,722.63 | 85,27,504.39 | =SUM(B11:G11) | ||
| Cost of Goods Sold | 13,19,724.83 | 26,83,424.70 | 37,99,653.92 | - | 17,81,021.83 | 33,25,726.71 | =SUM(B12:G12) | ||
| Gross Margin | =B11-B12 | =C11-C12 | =D11-D12 | =E11-E12 | =F11-F12 | =G11-G12 | =SUM(B13:G13) | ||
| Expenses | |||||||||
| Bonus | =B11*$B$2 | =C11*$B$2 | =D11*$B$2 | =E11*$B$2 | =F11*$B$2 | =G11*$B$2 | =SUM(B16:G16) | ||
| Commission | =B11*$B$3 | =C11*$B$3 | =D11*$B$3 | =E11*$B$3 | =F11*$B$3 | =G11*$B$3 | =SUM(B17:G17) | ||
| Marketing | =B11*$B$4 | =C11*$B$4 | =D11*$B$4 | =E11*$B$4 | =F11*$B$4 | =G11*$B$4 | =SUM(B18:G18) | ||
| Research and Development | =B11*$B$5 | =C11*$B$5 | =D11*$B$5 | 3,00,000.00 | =F11*$B$5 | =G11*$B$5 | =SUM(B19:G19) | ||
| Support, General and Administrative | =B11*$B$6 | =C11*$B$6 | =D11*$B$6 | 8,50,000.00 | =F11*$B$6 | =G11*$B$6 | =SUM(B20:G20) | ||
| Total Expenses | =SUM(B16:B20) | =SUM(C16:C20) | =SUM(D16:D20) | 11,50,000.00 | =SUM(F16:F20) | =SUM(G16:G20) | =SUM(B21:G21) | ||
| Operating Income | =B13-B21 | =C13-C21 | =D13-D21 | =E13-E21 | =F13-F21 | =G13-G21 | =H13-H21 |
Add Answer to:
5.00% What If Assumption Bonus Commission Marketing Research and Development Support, General, and Administrative 5.00% 5.75%...
True or False Research & Development is an Operating Expense. Cost of revenues include selling, general...
True or False Research & Development is an Operating Expense. Cost of revenues include selling, general & administrative expenses. Gross profit is calculated by dividing gross margin by revenues. Interest income is earned on a company’s cash and marketable securities. Non-operating income (expenses) are interest and other income (or expenses) unrelated to the provision of goods or services. Research and development are expenses incurred in enhancing and innovating products. Cost of revenues is calculated by subtracting operating expenses from revenues....
You are evaluating the HomeNet project under the following assumptions: new tax laws allow 100% bonus...
You are evaluating the HomeNet project under the following
assumptions: new tax laws allow 100% bonus depreciation (all the
depreciation expense, $ 7.5 million, occurs when the asset is put
into use, in this case immediately). Research and development
expenditures total $ 15 million in year 0 and selling, general,
and administrative expenses are $ 2.8 million per year (assuming
there is no cannibalization). Also assume HomeNet will have no
incremental cash or inventory requirements (products will be
shipped directly...
Managerial Accounting Can anyone Help me with these, and include the calculations in order for me...
Managerial Accounting
Can anyone Help me with these, and include the
calculations in order for me not to hardcode the numbers
because I need to use the excel formulas.
Thank you
Project #2 Sales Projections in Units January February March April |May 13,402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 44.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 Materials 64.6% 11.0 Desired Ending Inventory...
Year 1 Transactions for Adomain Transaction # Date Event 1 January 1 Purchased a patent for...
Year 1 Transactions for Adomain
Transaction #
Date
Event
1
January
1
Purchased a patent for $32,000 in cash
2
March
15
Paid $18,500 in cash for long-term assets
3
April
1
Prepaid
$36,000 for rent for the next 12 months and recorded the
transaction as an asset.
4
April
1
Issued
1000 common shares to investors for $60,000
5
April
1
Sold inventory
on account for $120,000 (a). The cost of the inventory was $16,000
(b). Also, paid a...
Oracle Corporation (ORCL) Income Statement All numbers in thousands Revenue 5/31/2018 5/31/2017 5/31/2016 5/31/2015 Total Revenue...
Oracle Corporation (ORCL) Income Statement
All numbers in thousands
Revenue
5/31/2018
5/31/2017
5/31/2016
5/31/2015
Total Revenue
39,831,000
37,728,000
37,047,000
38,226,000
Cost of Revenue
8,081,000
7,469,000
7,479,000
7,532,000
Gross Profit
31,750,000
30,259,000
29,568,000
30,694,000
Operating Expenses
Research Development
6,091,000
6,159,000
5,787,000
5,524,000
Selling General and Administrative
9,720,000
9,373,000
9,039,000
8,732,000
Non Recurring
-
-
-
-
Others
-
-
-
-
Total Operating Expenses
25,512,000
24,452,000
23,943,000
23,937,000
Operating Income or Loss
14,319,000
13,276,000
13,104,000
14,289,000
Income from Continuing Operations
Total...
On April 20, 2001, Yan Fangjiao, general manager of the Instruments Division of Stone Group Corp....
On April 20, 2001, Yan Fangjiao, general manager of the Instruments Division of Stone Group Corp. in Beijing, China, received a phone call from Lu Feng, sales representative of the Instruments Division. Feng was calling to ask Yan whether he should sell three Model HP34401A digital multimeters from the Instruments Division to the Industrial Controllers Division and what transfer price should be used if he did want to sell. Yan had to consider the appropriate accounting principles that applied in...
Patterson Manufacturing Background Columbia invests in family-owned businesses with a strong presence in niche markets....
Patterson Manufacturing
Background
Columbia invests in family-owned businesses with a strong
presence in niche markets. Columbia retains existing management and
local business practices but provides centralized services, such as
finance, accounting, insurance, and corporate-level management.
Patterson has remained profitable since the acquisition, but its
return on investment has been declining.
Your first stop at the Patterson complex is a meeting with the
controller. He provides some additional background:
“Jessica, like her predecessors, spent most of her time with
customers developing...
Required: 1. What is the amount of Apple’s accounts receivable as of September 30, 2017? 2....
Required:
1. What is the amount of Apple’s accounts
receivable as of September 30, 2017?
2. Compute Apple’s accounts receivable turnover as
of September 30, 2017.
3. How long does it take, on average, for
the company to collect receivables for fiscal year ended September
30, 2017?
4. Apple’s most liquid assets include (a)
cash and cash equivalents, (b) short-term marketable
securities, (c) accounts receivable, and (d)
inventory. Compute the percentage that these liquid assets (in
total) make up of...
Please answer all questions and make answers very clear. Thank you so much and I will...
Please answer all questions and make answers very clear. Thank
you so much and I will make sure to give a good rating!!!
Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not need to include...
You are evaluating the HomeNet project under the following
assumptions: new tax laws allow 100% bonus depreciation (all the
depreciation expense, $ 7.5 million, occurs when the asset is put
into use, in this case immediately). Research and development
expenditures total $ 15 million in year 0 and selling, general,
and administrative expenses are $ 2.8 million per year (assuming
there is no cannibalization). Also assume HomeNet will have no
incremental cash or inventory requirements (products will be
shipped directly...
Managerial Accounting
Can anyone Help me with these, and include the
calculations in order for me not to hardcode the numbers
because I need to use the excel formulas.
Thank you
Project #2 Sales Projections in Units January February March April |May 13,402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 44.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 Materials 64.6% 11.0 Desired Ending Inventory...
Year 1 Transactions for Adomain
Transaction #
Date
Event
1
January
1
Purchased a patent for $32,000 in cash
2
March
15
Paid $18,500 in cash for long-term assets
3
April
1
Prepaid
$36,000 for rent for the next 12 months and recorded the
transaction as an asset.
4
April
1
Issued
1000 common shares to investors for $60,000
5
April
1
Sold inventory
on account for $120,000 (a). The cost of the inventory was $16,000
(b). Also, paid a...
Oracle Corporation (ORCL) Income Statement
All numbers in thousands
Revenue
5/31/2018
5/31/2017
5/31/2016
5/31/2015
Total Revenue
39,831,000
37,728,000
37,047,000
38,226,000
Cost of Revenue
8,081,000
7,469,000
7,479,000
7,532,000
Gross Profit
31,750,000
30,259,000
29,568,000
30,694,000
Operating Expenses
Research Development
6,091,000
6,159,000
5,787,000
5,524,000
Selling General and Administrative
9,720,000
9,373,000
9,039,000
8,732,000
Non Recurring
-
-
-
-
Others
-
-
-
-
Total Operating Expenses
25,512,000
24,452,000
23,943,000
23,937,000
Operating Income or Loss
14,319,000
13,276,000
13,104,000
14,289,000
Income from Continuing Operations
Total...
Patterson Manufacturing
Background
Columbia invests in family-owned businesses with a strong
presence in niche markets. Columbia retains existing management and
local business practices but provides centralized services, such as
finance, accounting, insurance, and corporate-level management.
Patterson has remained profitable since the acquisition, but its
return on investment has been declining.
Your first stop at the Patterson complex is a meeting with the
controller. He provides some additional background:
“Jessica, like her predecessors, spent most of her time with
customers developing...
Required:
1. What is the amount of Apple’s accounts
receivable as of September 30, 2017?
2. Compute Apple’s accounts receivable turnover as
of September 30, 2017.
3. How long does it take, on average, for
the company to collect receivables for fiscal year ended September
30, 2017?
4. Apple’s most liquid assets include (a)
cash and cash equivalents, (b) short-term marketable
securities, (c) accounts receivable, and (d)
inventory. Compute the percentage that these liquid assets (in
total) make up of...
Please answer all questions and make answers very clear. Thank
you so much and I will make sure to give a good rating!!!
Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not need to include...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago