125% T e ca View Zoom Add Category Insert Table Chart Text Shape Media Comment Collaborate Format Organize + Template Solution Sheet3 Table Cell Text Arrange o A B D E F G H 1 J L MN O R S 1 P-02 Name: Section : 2 3 4 Enter the appropriate amount or item in the shaded cells. Use the drop-down lists when available. An asterisk (*) will appear next to an incorrect entry in the outlined cells. 5 6 2 7 8 Preparing a Comprehensive Budget. Table Styles 1 9 10 11 Bathworks Sales Budget For the Year Ended December 31 Quarter 1 2 Table Options Title Caption 12 13 3 4 Year 14 3,000 5,000 5,000 17,000 15 16 17 Sales in Units Selling Price per unit Total Sales 4,000 $6 $ 24,000 Headers & Footer HO mo 0000 2 Rows 166 18 19 20 21 22 23 24 Columns 21 Bathworks Production Budget For the Year Ended December 31 Quarter 1 2 25 3 4 Year Table Font Size A A 4,000 Table Outline 26 27 28 29 30 31 32 600 600 Sales in units Plus desired units of ending finished goods inventory(a) Desired total units Less desired units of beginning finished goods inventory(b) Total production units 300 4,300 1 pt Outline Table Title 400 400 3,900 33 34 Gridlines 2. (a) Desired units of ending finished goods Inventory = 10% of next quarter's budgeted sales. (b) Desired units of beginning finished goods Inventory = 10 % of current quarter's budgeted sales. 35 36 37 38 39 Alternating Row Color 3 40 41 Bathworks Direct Material Purchase Budget For the Year Ended December 31 Quarter Row & Column Size 42 43 Height 14 pt Fit Width 79 pt Fit