Question

In: Finance

Instructions Your manager wants a 15% increase on December Year 2 sales vs December Y1 Sales....

Instructions
Your manager wants a 15% increase on December Year 2 sales vs December Y1 Sales. Dec Y2 sales must be 15% higher than Dec Y1 sales.
Input the amount necessary to reach 15% (Dec Y2 over Dec Y1). The increase must be the same every month until Dec y2 is 15% higher than Dec y1.
Must use formulas to compute the answers.
SALES Y1 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2
December January February March April May June July August September October November December
Product 1 1,900
Product 2 1,500
Product 3 2,500

Solutions

Expert Solution

Increase required in 12 months = 15%

Increase required each month = SalesDecY1*(0.15/12)

SALES Y1 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2 Y2
December January February March April May June July August September October November December
Product 1 1900 1923.75 1947.50 1971.25 1995.00 2018.75 2042.50 2066.25 2090.00 2113.75 2137.50 2161.25 2185.00
Product 2 1500 1518.75 1537.50 1556.25 1575.00 1593.75 1612.50 1631.25 1650.00 1668.75 1687.50 1706.25 1725.00
Product 3 2500 2531.25 2562.50 2593.75 2625.00 2656.25 2687.50 2718.75 2750.00 2781.25 2812.50 2843.75 2875.00

Formula Used -

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Your firm wants to increase sales by 12% in 2020. 2019 sales were $1,800,000. The firm...
Your firm wants to increase sales by 12% in 2020. 2019 sales were $1,800,000. The firm has $4,500,000 in total assets. The firm has $600,000 in accounts payable on its balance sheet, along with $250,000 in accruals. The firm has a 6% profit margin, and the firm typically pays out 10% of its net income. How much of the additional funds, if any, will be sourced from debt?
15. AT&U Company has the following data for the year ended December 31, Year 1: Sales...
15. AT&U Company has the following data for the year ended December 31, Year 1: Sales (credit) $2,500,000 Sales returns and allowances 50,000 Accounts receivable (December 31, Year 1) 640,000 Allowance for doubtful accounts      (before adjustment at December 31, Year 1) 20,000 Estimated amount of uncollected accounts based on aging analysis (December 31, Year 1) 45,000 Refer to AT&U Company. If the company estimates its bad debt to be 2% of net credit sales, what will be the balance...
A branch manager has 4 inside sales employees. The manager wants to know if there is...
A branch manager has 4 inside sales employees. The manager wants to know if there is any difference between these employees in terms of average time to enter an order into the system. You are tasked to evaluate the collected data and prepare a report regarding your findings. Order Number Employee I Employee II Employee III Employee IV Time to Enter (in minutes) 1 5 12 8 10 2 7 12 11 9 3 9 2 7 5 4 6...
If the price of a good falls by 15% and sales increase by 18%, what is...
If the price of a good falls by 15% and sales increase by 18%, what is the approximate price elasticity of demand at that price? Please show steps as well.
Problem 15-6 (LG 15-2) a. Suppose a 65-year-old person wants to purchase an annuity from an...
Problem 15-6 (LG 15-2) a. Suppose a 65-year-old person wants to purchase an annuity from an insurance company that would pay $22,000 per year until the end of that person’s life. The insurance company expects this person to live for 15 more years and would be willing to pay 7 percent on the annuity. How much should the insurance company ask this person to pay for the annuity? b. A second 65-year-old person wants the same $22,000 annuity, but this...
Sales = 11996.6 COGS = 7695 Profit = 4302 If the company wants to increase the...
Sales = 11996.6 COGS = 7695 Profit = 4302 If the company wants to increase the profit by 10% what should the sales and cogs be?
The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase...
The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase by 1 percent each month over the previous month’s sales from December 2015 through March 2016. Then sales are expected to remain constant for several months. Helping Hand’s projected balance sheet as of December 31, 2015 is as follows: Cash $ 60,000 Accounts receivable 172,530 Marketable securities 10,000 Inventory 39,784 Buildings and equipment (net of accumulated depreciation) 600,000 Total assets $ 882,314 Accounts payable...
The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase...
The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase by 1 percent each month over the previous month’s sales from December 2015 through March 2016. Then sales are expected to remain constant for several months. Helping Hand’s projected balance sheet as of December 31, 2015 is as follows: Cash $ 60,000 Accounts receivable 172,530 Marketable securities 10,000 Inventory 39,784 Buildings and equipment (net of accumulated depreciation) 600,000 Total assets $ 882,314 Accounts payable...
The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase...
The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase by 1 percent each month over the previous month’s sales from December 2015 through March 2016. Then sales are expected to remain constant for several months. Helping Hand’s projected balance sheet as of December 31, 2015 is as follows: Cash $ 60,000 Accounts receivable 172,530 Marketable securities 10,000 Inventory 39,784 Buildings and equipment (net of accumulated depreciation) 600,000 Total assets $ 882,314 Accounts payable...
2. The manager of a restaurant wants to know if there is a correlation between the...
2. The manager of a restaurant wants to know if there is a correlation between the amount of a customer’s bill and the percent that they tip. In other words, as people spend more money do they tend to tip at different rates? With data from a random sample of 157 bills, he used StatKey to construct a 95% bootstrap confidence interval of [0.018, 0.292] for r. [24 points] A. What if the manager wanted to do a hypothesis test...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT