I need sub part 6 and 7 answered please A portion of Leslie's operating information for the company's last year follows:Number ofOperatingCostMonthJerseys Printed$5,735JanuaryFebruaryMarch2002055,8308,6909,8009,2756,2306,140575AprilMay680625June410JulyAugustSeptemberOctober3902305,9404,8106,005180305NovemberDecember2355,9604,955190Required:3. Using the high-low method, calculate the store's total fixed operating costs and variable operating cost per jersey.4. Using the high-low method results, calculate the store's expected operating cost if it printed 455 jerseys.5. Perform a least-squares regression analysis on Leslie's data.6. Using the regression output, create a linear equation (y= a+ bx) for estimating Leslie's operating costs.7. Using the least-squares regression results, calculate the store's expected operating cost if it prints 600 jerseys.Complete this question by entering your answers in the tabs below.Required 3Required 4Required 5Required 6Required 7Using the regression output, create a linear equation (y = a + bx) for estimating Leslie's operating costs. (Round youranswers to 2 decimal places.)Total Cost =(Number of Jerseys)+< Required 5Required 7 >

5. Perform a least-squares regression analysis on Leslie's data. 6. Using the regression output, create a linear equation (y = a+ bx) for estimating Leslie's operating costs. 7. Using the least-squares regression results, calculate the store's expected operating cost if it prints 600 jerseys.

5. Perform a least-squares regression analysis on Leslie's data. 6. Using the regression output, create a linear equation (y = a+ bx) for estimating Leslie's operating costs. 7. Using the least-squares regression results, calculate the store's expected operating cost if it prints 600 jerseys.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

General ledger of Su Mari Traders Debtors Control 2020 30? 2020 CRJ DAJ Sundry accounts (Journal credits) GJ 1Balance b/d 51 000,00 Jun 42 000,00 Jun 13 800 30 Sales 8 000,00 Bank CPJ 2 400,00 12 200,00 Sundry accounts Ljournal debits) ? 1 600,00 Balance 1. Calculate the balance carried down to July 2020 2. Provide possible explanation for the R8000 on the credit side 3. Provide possible explanation for the R2400 on the debit side 4. Give a reason for the entry of R12 200 on the credit side 5. Should the business worry about the control over their debtors this month
On December 31, 2019, the unadjusted trial balance of Tarzwell Services showed the following balances: Accounts receivable Allowance for doubtful accounts Sales $200,000 1,000 Cr. 700,000 The business has given up trying to collect $5,000 of its accounts receivable but has not yet recorded the write-off entry. The firm uses the allowance method to estimate bad-debt expense. Required a) Provide the entry for the write-off. b) If the firm uses the percent-of-sales allowance method for recording bad-debt expense, and has experienced an average 6% rate of non-collection based on sales, provide the entry to record bad-debt expense for 2019. c) Assume that after the firm recorded the $5,000 of write-offs, it determined that 18% of its remaining accounts receivable will be uncollectible under the aging method. Provide the entry to record bad-debt expense. Don't give answer in image format
none of the above 17 18 Question 25 (1 point) ✔Saved 20 20 21 2 23 25 ✓ 24 24 Quiz Information @ 2 # * $ 3 4 Which of the following is not one of the Bardal Factors affecting the length of common law notice to which an employee would be entitled upon termination of employment? Age Length of Service Position of the Employee All of the above are Bardal Factors Submit Quiz 25 of 25 questions saved = e ZM f6 f5 Jo 5 6 & 7 IN hp ao f8 f9 KA f10 f11 f12 ins prt sc * 8 9 delete 奶 backspace W E R T Y U O P [ S D F G H J K X C V B N Σ アド L- 1 pause alt ctri < に
Q3.6 (Algo) Valley Forge Income Tax [3.6] VF is a small accounting firm supporting wealthy individuals in their preparation of annual income tax statements. Every December, VF sends out a short survey to their customers, asking for the information required for preparing the tax statements. Based on 24 years of experience, VF categorizes their cases into the following groups: • Group 1 (new customers, easy): 15 percent of cases • Group 2 (new customers, complex): 10 percent of cases Group 3 (repeat customers, easy): 50 percent of cases . Group 4 (repeat customers, complex): 25 percent of cases Here, "easy" versus "complex" refers to the complexity of the customer's earning situation. In order to prepare the income tax statement, VF needs to complete the following set of activities. Processing times (and even which activities need to be carried out) depend on which group a tax statement falls into. All of the following processing times are expressed in minutes per income tax statement.…
9. Nizwa Company bought an equipment for manufacturing tube lights and the company management requested you to analyze and submit the report regarding the four major factors that required to consider for calculating depreciation of an equipment?
Please do not give solution in image formate thanku. Organisational financial programmes that allow full withdrawal at retirement is called a/n: Question 4Select one: a. Pension plan b. Retirement annuity c. Investment policy d. Provident fund
Q14 Which of the following is a serious problem associated with historical cost based financial statements in periods of inflation? a. Asset understatement b. Overstated Income c. Overpayment of income taxes d. All of these options given are potential problems
Capital Budgeting with Taxes (Non-MACRS Depreciation); Sensitivity Analysis GravinaCompany is planning to spend $6,000 for a machine that it will depreciate on a straight-line basisover 10 years with no salvage value. The machine will generate additional cash revenues of $1,200 ayear. Gravina will incur no additional costs except for depreciation. Its income tax rate is 35%. Thepresent value annuity factor for 15%, 10 years (from Appendix C, Table 2) is 5.019.Required1. What is the payback period of the proposed investment (in years, and rounded to 1 decimal place) underthe assumption that the cash inflows occur evenly throughout the year?2. What is the accounting (book) rate of return (ARR) based on the initial investment outlay? Round youranswer to 1 decimal place (e.g., 13.571% = 13.6%).
Kamal Fatehl production manager of Kennesaw Manufacturing, finds his profit at $22,400 (as shown in the statement below) inadequate for expanding his business. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Kamal would like to improve profit line to $32,400 so he can obtain the bank's approval for the loan. % of sales Sales 280,000 100% Cost of supply chain purchases 201,600 72% Other production costs 28,000 10% Fixed costs 28,000 10% Profit 22,400 8% Part 2 a) What percentage…
Present the Income Statement Format of a Manufacturing Business. (Please help me answer it, thank you)
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMS for the past two years were as follows: Use Exhibit 18.10. LAST YEAR QUANTITY QUARTER (UNITS) THIS YEAR QUANTITY QUARTER (UNITS) 15 15 II III 21 II 27 31 29 19 III IV IV 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.)
The data shown are quarterly revenues (in Sthousands) from Roget's Books from 2013-Q1 through 2020-Q2. 6. Quarter 2013-1 2013-2 2013-3 2013-4 2014-1 2014-2 2014-3 2014-4 2015-1 2015-2 2015-3 2015-4 2016-1 2016-2 2016-3 2016-4 2017-1 2017-2 2017-3 2017-4 Revenue 2372 2740 2518 4708 2392 Quarter 2018-1 2018-2 2018-3 2018-4 2019-1 2019-2 2019-3 2019-4 2020-1 2020-2 Revenue 2725 2924 3118 5112 2777 2949 1:27:04 2811 2685 4795 2812 2893 2848 4894 2687 2903 2674 4871 2844 2933 3237 5350 3035 3028 2791 5252 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = | (Round to 1 decimal places.) b. Determine the specific index for each quarter places.) dexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for…