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.
-
A sample of size 31 will be drawn from a population with mean 39
and standard...
asked 5 minutes ago -
What is the effect on the P-value when a test is changed from a
two-tailed hypothesis...
asked 10 minutes ago -
I wish to estimate µ, the mean of a population. After I collect
and an-
alyze...
asked 39 minutes ago -
At a local university, you poll a group of 115 students and find
that 37 of...
asked 20 minutes ago -
Gladstone company tracks the number of units purchased and sold
throughout each accounting period but applies...
asked 23 minutes ago -
When determining if a molecule's configuration is E or Z, what
determines the higher priority groups?
asked 27 minutes ago -
13. What is the amount
of conversion cost transferred to finished goods? (Round
your intermediate calculations...
asked 29 minutes ago -
Sulfuric Acid is a "strong" acid, but only releases a single
proton when it dissolves. What...
asked 28 minutes ago -
The
second floor of a house is 6 m above the street level. How much
work...
asked 31 minutes ago -
What uncontrollable factor(s) contributed to Hong Kong Disney’s
poor performance during its first year?
asked 32 minutes ago -
You are interested in whether students that have a male
instructors perform differently on exams. To...
asked 44 minutes ago -
Discuss the following: The policies that promote economic
growth. Why are some countries more developed than...
asked 40 minutes ago