Question

Division Profitability

	Quarter 1	Quarter 2	Quarter 3	Quarter 4	graph
GROSS PROFIT
Revenues	0	0	1,056,604	1,597,853
- Rebates	0	0	16,500	23,750
- Cost of Goods Sold	0	0	410,486	581,268
= Gross Profit	0	0	629,618	992,835
EXPENSES
Store Leases	0	0	90,000	144,000
+ Sales and Service Personnel Expense	0	0	99,571	149,429
+ Brand Promotions	0	0	0	0
+ Special Programs	0	0	0	0
+ Ad Creation/Revision	0	0	24,000	12,000
+ Point of Purchase Display Expenses	0	0	800	1,800
+ Advertising Expenses	0	0	17,454	34,747
+ Internet Marketing Expenses	0	0	2,000	2,000
+ Engineering Cost for New Brands	0	150,000	0	90,000
+ Market Research	88,000	0	20,000	60,000
= Operating Expenses	88,000	150,000	253,825	493,976
Operating Profit	-88,000	-150,000	375,793	498,859
MISCELLANEOUS INCOME AND EXPENSES
+ Other Income	0	0	0	0
- Other Expenses	0	0	0	0
- Research and Development Costs	0	0	0	0
- Set Up Costs for New Stores	0	438,000	146,000	180,000
= Net Profit for Division	-88,000	-588,000	229,793	318,859
Cumulative Net Profit for Division	-88,000	-676,000	-446,207	-127,348

I am needing projections of profits of the next three quarters?

What would the return on investment be by the end of the second year?

Answer 1

The rate of retuen and projections are

	Year 1	Growth Rate	Year 2
Particulars	Q1	Q2	Q3	Q4		Q1	Q2	Q3	Q4
Revenue	-	-	1,056,604	1,597,853	51.23%	2,416,359	3,654,147	5,525,996	8,356,706
Rebates	-	-	16,500	23,750	43.94%	34,186	51,697	78,179	118,227
COGS	-	-	410,486	581,268	41.60%	823,104	1,244,741	1,882,364	2,846,611
Gross Profit	-	-	629,618	992,835		1,559,069	2,357,708	3,565,452	5,391,867
Expenses :
Store Leases	-	-	90,000	144,000	60.00%	230,400	348,423	526,904	796,813
Sales & Services Perssonel	-	-	99,571	149,429	50.07%	224,252	339,126	512,845	775,551
Brand Promotion	-	-	-	-	0.00%	-		-	-
Special Programme	-	-	-	-	0.00%	-	-	-	-
Ad creation	-	-	24,000	12,000	-50.00%	6,000	3,000	1,500	750
Point of pur daily exp	-	-	800	1,800	125.00%	4,050	6,125	9,262	14,006
advertising exp	-	-	17,454	34,747	99.08%	69,173	104,608	158,194	239,229
Internet marketing exp	-	-	2,000	2,000	0.00%	2,000	3,025	4,574	6,917
engg cost	-	150,000	-	90,000	-40.00%	-	36,000	-	14,400
market research	88,000	-	20,000	60,000	200.00%	180,000	272,206	411,644	622,510
Total operating expenses	88,000	150,000	253,825	493,976		715,876	1,112,512	1,624,922	2,470,176
Operating Profit	(88,000)	(150,000)	375,793	498,859		843,194	1,245,196	1,940,530	2,921,691
Misc Income & Expense :
Other Income	-	-	-	-
Other Expense	-	-	-	&nb ekkarill92 Next > < Previous Related Solutions 1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following:... 1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following: Yr. 1 Revenues 500 COGS 400 Gross Profit 100 Gross Margin 20% Sales rise 5%, 3% due to increase in volume and 2% due to increase in price. COGS is 80% variable. 2. What is the primary driver of sales growth for the following company? Explain. Assume COGS is 60% variable. Yr. 1 Yr. 2 Revenues 800    850 COGS 500 519 Gross Profit... A= 1 2 4 0 1 -2 -1 0 1 2 0 3 8 1 4... A= 1 2 4 0 1 -2 -1 0 1 2 0 3 8 1 4 . Let W denote the row space for A. (a) Find an orthonormal basis for W and for W⊥. (b) Compute projW⊥(1 1 1 1 1 ). exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6... exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6 1 5 6 8 2 4 6 7 3 4 5 9 10 5 8 9 4 7 9 6 7 8 6 How can I detect when 'cin' starts reading from a new line. The amount of numbers in each row is unknown. I need them in type 'int' to use the data.   Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales...   Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000   Selling price per unit $7 per unit             1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance... 0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4. 0. 0. 0. 0.0. 0. 0. 0. 0.   1. 1. 1. 1. 1. 1. 2. 2. 2. 3.   4. A.)MEAN – B.)MEDIAN - C.)MODE - D.)STANDARD DEVIATION – E.)5 NUMBER SUMMARY – F.)BOX AND WHISKERS PLOT – G.) OUTLIERS- 0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4. 0. 0. 0. 0.0. 0. 0. 0. 0.   1. 1. 1. 1. 1. 1. 2. 2. 2. 3.   4. A.)5 NUMBER SUMMARY – B.)BOX AND WHISKERS PLOT – C.) OUTLIERS- 1. Which of the following is considered the better measures of profitability? a. Gross profit margin... 1. Which of the following is considered the better measures of profitability? a. Gross profit margin b. Operating profit margin c. Net profit margin d. Sales e. None of the above 2. Which of the following allows for comparisons across companies on a “per unit” bases using a common denominator? a. Current ratio b. Inventory turnover c. Long- term debt ratio d.Earrings per share E. None of the above 3. Which of the following compares form of financing assets? a.... Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1... Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter • Finished... Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1... Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales        40,000         60,000      100,000      50,000         70,000         80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales... URGERNT Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total paper, toner, printer maintenance, and postage... URGERNT Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total paper, toner, printer maintenance, and postage costs . . . $633,000 $645,000 $780,000 $660,000 Total number of bills mailed . . . . . . . . . . 545,000 585,000 720,000 600,000 1. Calculate the variable cost per bill mailed under the current​ paper-based billing system. 2. Assume that the company projects that it will have a total of 800,000 bills to mail in the upcoming quarter. If enough... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions The three principal rays for converging (concave) mirrors: 1. Any incident ray parallel to the principal... Given a connected graph G with n vertices. We say an edge of G is a... Let iqsort(A, 1, n) be an algorithm that sorts an array A with n integers. It... Write a program to print the number of class assignments you have done so far, the... This is in C# on visual Basic Write a base class that has two property members:... Greta, an elderly investor, has a degree of risk aversion of A = 3 when applied... Should certain categories of drugs be decriminalized? What might the impact be – in the short-... ADVERTISEMENT About @ 2020 WizEdu