Question

Lewellen Products has projected the following sales for the coming year:

	Q1			Q2			Q3			Q4
Sales	$	840		$	920		$	880		$	980

Sales in the year following this one are projected to be 10 percent greater in each quarter.

a.	Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

	Q1	Q2	Q3	Q4
Payment of accounts	$	$	$	$

b.	Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

	Q1	Q2	Q3	Q4
Payment of accounts	$	$	$	$

c.	Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

	Q1	Q2	Q3	Q4
Payment of accounts	$	$	$	$

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) View Add-Ins File Home Insert Page Layout Formulas Data Review - 2x % Cut A = = = V General Wrap Text Merge Merge & Center - Center Σ AutoSum : A Fill Z Sort & SF $ % % , 4:0 .00 :.: Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Filter Editing Find & Select Alignment Number Cells Q1 840 Q2 920 Q3 880 Q4 NEXT YEAR Q1 980 924.00 (10% INCREASE) (840 + 10%) 277.20 (30%*924) Calibri 11 A E Copy Paste Format Painter BI U D- DA Clipboard Font B512 fx А в 512 513 514 515 SALES 516 517 518 a PAYMENT OF ACCOUNTS 519 (IMMEDIATELY) 520 521 b PAYMENT OF ACCOUNTS 522 (90 DAYS) 523 524 C PAYMENT OF ACCOUNTS 525 (60 DAYS) 526 527 528 529 530 FIFO CASH BUDGET budget 45 days Rea ferences 276.00 (30%*920) 264.00 (30%*880) 294.00 (30%*980) 252.00 (30%*840) 276.00 (30%*920) 264.00 (30%*880) 294.00 (30%*980) 274.00 288.40 260.00 272.00 [=30%*(2/3)*(C515)+30%*(1/3)*(D515)] 2/3 PAYABLE FOR CURRENT QUARTER SALES & 1/3 PAYABLE OF NEXT QUARTER SALES SAME WAY FOR OTHER QUARTERS cycle ROE, BV MV ratio VARIANCE BEP, OL FL ratios DETROIT float B-S profit loss SALES BUDGET dupont 0 DIFF ANALYSIS ovel < BOH 130% ...B 199 * 10 ENG 24-11-2019