A shoe store developed the following estimated regression equation relating sales to inventory investment and advertising expenditures. ŷ= 29+ 10x1 + 6x2 where x=inventory investment ($1,000s) X2 y advertising expenditures ($1,000s) sales ($1,000s). (a) Predict the sales (in dollars) resulting from a $14,000 investment in inventory and an advertising budget of $11,000. $ 15,000 (b) Interpret b, and b₂ in this estimated regression equation. Sales can be expected to increase by $ 10,000 expected to increase by $231,000 X for every dollar increase in inventory investment when advertising expenditure is held constant. Sales can be X for every dollar increase in advertising expenditure when inventory investment is held constant.

A shoe store developed the following estimated regression equation relating sales to inventory investment and advertising expenditures. ŷ= 29+ 10x1 + 6x2 where x=inventory investment ($1,000s) X2 y advertising expenditures ($1,000s) sales ($1,000s). (a) Predict the sales (in dollars) resulting from a $14,000 investment in inventory and an advertising budget of $11,000. $ 15,000 (b) Interpret b, and b₂ in this estimated regression equation. Sales can be expected to increase by $ 10,000 expected to increase by $231,000 X for every dollar increase in inventory investment when advertising expenditure is held constant. Sales can be X for every dollar increase in advertising expenditure when inventory investment is held constant.

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter10: Forecasting Financial Statement

Section: Chapter Questions

Problem 5QE: Use the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of...

See similar textbooks

Similar questions

Analyze the influence of factors on the level of return on sales (ROS). Choose the proper method of factor analysis. Year 200A Year 200B Sales, $'000 56000 58421 Cost of goods sold, $'000 48000 50024
Use the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreenss Year +1 revenue growth rate, gross profit margin, and inventory turnover will be identical to Year 12. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance.
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
Marketing: Determine the marketing return on sales (marketing ROS) and return on marketing investment (marketing ROI) for Company A and Company B in the chart below. Which company is performing better? Company A Company BNet sales 1,240,000 980,000Cost of goods sold 568,000 430,000Sales expenses 400,000 70,000 Fill in the table below. (Round the NMC to the nearest dollar and all other values to the nearest whole number.) Company A Company B NMC $ $
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Company’s purchasing cost and number of purchase orders.The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Intercept 15,021 (rounded to the nearest dollar)X variable 1 9.74 (rounded to the nearest cent) Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the vari-able rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchaseorders, what is the total estimated purchasing cost for that month? (Round your answer tothe nearest dollar.)3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year andexpects 5,340 purchase orders? What will estimated total purchasing cost be? (Round youranswer to the nearest dollar.) What is the total fixed purchasing cost? Why doesn’t it equalthe fixed cost calculated in Requirement 1?
A.Establish the Total Sales and Average Sales at an appropriate area in the spreadsheet. B.In an appropriate area of the spreadsheet calculate the following as it relates to the sales volumes: Minimum, Maximum, Middle values C. There was an error in the calculated sales volumes, wherein all sales volumes should have increased by 5%. To the right of the sales volume heading, create a heading called Increased Sales Volumes where this 5% increase must be reflected below
Compute the following transactions using multi-step income statement2. Calculate Sales Returns and Allowances and Cost of Merchandise Sold if,Sales are Php 750,000, Sales Discounts are Php 9,000, Net Sales are Php 736,000 andGross Profit is Php 310,000.
1. If last year's sales were $906,050 and a store was planning an increase in sales of 3.75% and a markdown percent of 18.25%, what is the planned markdown in dollars? (Present your answer rounded to the dollar with a dollar sign and comma separator (i.e. $109,455).) 2. Using the following data, calculate the planned April purchases at cost. (Present your answer rounded to the dollar with a dollar sign and comma separator (i.e. $109,455).) Sales $220,000 BOM Stock for April $380,000 BOM Stock for May $240,000 Markup 51% Markdowns 2.3%
Compute the following transactions using multi-step income statement 1. Calculate Net Sales and Gross Profit if, Sales are Php 375,000, Sales Returns and Allowances arePhp32,000, Sales Discounts are Php 12,000 and Cost of MerchandiseSold is Php 255,000.
YEAR SALES WEIGHTS 1 $1,079,864 0.1 2 $1,238,586 0.2 3 $1,409,078 0.3 4 $1,098,274 0.1 5 $1,578,968 0.3 6 ? ? 1. Using the sales information above, calculate both the averaging and the weighted sales forecasts using Microsoft Excel. Be sure to write the simple formulas in the spreadsheet, rather than calculating the answers by hand and entering the numbers directly into the spreadsheet. In addition, do the following with your spreadsheet. Brief instructions on how to accomplish the Excel functions are below. a. Be sure the gridlines are showing for the print mode. b. Create a title for the table and include it on the top line of the spreadsheet. c. Be sure to include dollar signs where appropriate. Instructions for Excel 1. First, you need to…
Using Goal Seek/Solver and/or What-If Scenarios based on the below income statement, calculate the following a) the sales amount in order to realize $1,200,000 of net income without changing any of the expense accounts. b) to realize $1,200,000 without changing revenues and cost of goods sold. c) What could be the best scenario to achieve NI $1,200,000.
The manager of the West store has concerns relating to the store’s financial performance and has asked for help analyzing transfer costs. After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation. It may be helpful to perform a vertical analysis (i.e., perform a vertical analysis). warehouse west store sales $18,920 $43,860 cost of goods sold 9,082 21,053 gross profit $9,838 $22,807 selling expenses 860 2,752 wages expense 4,730 15,351 costs allocated from corporate 2,838 4,386 Total expenses $8,428 $22,489 operating income/(loss) $ ? ? Operating Income/(loss) % ? ?