Here are two more of my questions. Please just use my file. Also there are comments for cells with red indicator with required tokens don't worry about the other formatting though.

Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the 2013. She assumes that in some way supplies expense is related to sales, either in units or in dollars. She has coll December 2012, and has estimated sales for 2013. Date March-17 February-17 January-17 December-16 November-16 October-16 September-16 August-16 July-16 June-16 May-16 April-16 March-16 February-16 January-16 December-15 November-15 October-15 September-15 August-15 July-15 June-15 May-15 April-15 March-15 February-15 January-15 December-14 November-14 October-14 September-14 April-17 May-17 June-17 July-17 August-17 September-17 October-17 November-17 December-17 January-18 Supplies Expense $1,833 $2,356 $1,917 $1,273 $1,566 $2,779 $2,845 $1,736 $1,679 $1,982 $1,991 $2,599 $2,122 $1,615 $1,910 $1,831 $1,376 $2,923 $3,236 $1,343 $1,160 $2,972 $1,909 $1,733 $1,885 $1,603 $2,224 $2,241 $1,803 $2,074 $2,373 Sales Units 300 276 398 119 165 312 722 161 195 133 172 405 248 207 315 158 163 250 645 71 109 228 214 138 198 193 249 127 168 150 752 132 180 122 293 254 314 345 474 192 210 Sales Dollars $1,289 $1,608 $2,194 $1,432 $1,215 $1,659 $1,965 $1,193 $1,419 $1,409 $1,669 $2,285 $1,959 $1,463 $1,491 $1,309 $1,201 $2,140 $1,978 $1,391 $1,620 $1,856 $1,277 $1,595 $1,401 $1,288 $1,732 $1,450 $1,330 $1,536 $2,405 $1,043 $1,799 $1,245 $1,395 $1,766 $2,002 $1,660 $1,969 $1,741 $1,518 February-18 March-18 316 274 $2,056 $2,704 1. Develop the regression that Jean should use based on the above data and using the regression procedure REG You may locate your ATP Regression output starting in row 85. Model: Supplies Expense = F(Sales Units and Sales Dollars) R Square Coefficients Standard Error t Stat P-value Intercept Sales Units Sales Dollars Intercept Sales Units 2. What are the predicted monthly figures for supplies expense for 2013? Model to use: Date April-17 May-17 June-17 July-17 August-17 September-17 October-17 November-17 December-17 January-18 February-18 March-18 Sales Units 132 180 122 293 254 314 345 474 192 210 316 274 Sales Dollars $1,043 $1,799 $1,245 $1,395 $1,766 $2,002 $1,660 $1,969 $1,741 $1,518 $2,056 $2,704 Predicted Supplies Expense d supplies. Jean Raouth, the assistant manager, is in the process of budgeting monthly supplies expense for ts or in dollars. She has collected these data for sales and supplies expenses for June 2010 through e regression procedure REGRESSION in Excel Analysis Toolpak - enter the following Regression results. Supplies Expense = F(Sales Units) Supplies Expense = F(Sales Dollars) R Square R Square Coefficients Standard Error t Stat P-value Coefficients Intercept Sales Dollars Supplies Supplies Supplies Expense = Expense = F(Sales Units F(Sales = Expense F(Sales and Sales Units) Dollars) Dollars) Standard Error e = F(Sales Dollars) t Stat P-value Excel Instructions No additional Excel instructions No pivot tables, no tables/lists, no range names, no charts. sts, no range names, no charts. You (First name Last name) are a relatively recent hire to the Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare for a presentation to the company's management a condensed cash-flow statement for the months of November and December, 2013. The cash balance at November 1st was $54,300. It is the company's policy to maintain a minimum cash balance of $31,000 at the end of each month. Cash receipts (from cash sales and collection of accounts receivable) are projected to be $350,000 for November and $287,000 for December. Cash disbursements (sales commissions, advertising, delivery expense, wages, utilities, etc.), prior to financing activity, are scheduled to be $375,000 in November and $284,800 in December. Borrowing, when needed, is done at the beginning of the month - in increments of $600. The annual interest rate on any such loans is estimated to be 8.00%. Interest on any outstanding loans is paid in cash at the end of the month. Interest on any outstanding loans is paid in cash at the end of the month. Repayments of principal (if any) are assumed to occur at the end of the month. Required: Use the preceding information to prepare the cash budget for November and December. (Hint: The December 31st cash balance should be $.) Data Input: Cash balance, November 1st Minimum required cash balance Budgeted cash receipts: November December Budgeted cash disbursements: November December Interest rate on borrowings Short-term loan payable, as of November 1st Borrowings in increments of $54,300 $31,000 $350,000 $287,000 $375,000 $284,800 8.0% per year $0 $600 Solution: Cash Budget For November and December, 2013 November Cash balance, beginning Plus: Cash receipts Total Cash Available Cash disbursements, prior to financing Plus: Minimum cash balance (given) Total Cash Needed Excess (deficiency of) cash, before financing effects Financing: Balance Short term loan beginning of month Short-term borrowing, beginning of the month Repayments (loan principal), end of the month Balance Short term loan end of month Interest (@8.00%), paid in cash @ end of the month Total effects of financing Ending cash balance Most of the points are on cells I39, I40 and L39, L40 December Excel Instructions No additional Excel instructions No pivot tables, no tables/lists, no range names, no charts