C AC306 Unit 5 Assignment template Protected View] Excel Bryanna Marie Hardy Page Layout Data Review View Tell me what you want to do File Home Insert Formulas PROTECTED VIEW can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Be cateful-files from the Internel Updates for Office are ready be installed, but first we need to close some apps. Update now UPDATES AVAILABLE F G H M N D A 1 Enter titles and accounts in the green cells 2 Enter Numbers. in the blue cells 3 Enter your Calculations in the yellovi cells 4 Company manufactures table cloths. a. The Marketing Department has 5 The company is in the process developing next quarter's budgets and has gathered the following information for the budget preparation: Dallas estimated sales follows for the remainder of the year (in units): 6 7 July 25.000 October 20.000 August 40.000 November 25,000 September 39.000 December 37.500 11 . The selling price. 25 per unit 13 b. All sales are on account. Based on past experience, sales are collected in the following pattern: 17 25% in the month of sale 70% in the month following sale 5% uncollectible c. Sales for June totaled $525.000. 525000 31 goods inventory equal to 20 % the following month's sales. The June ending inventory will meet this requirement. d. The company desires to keep a finished Problem 1 Problem 2 Ready x B6 2013 AC306 Unit 5 Assignment template [Protected View) Excel Bryanna Marie Hardy G Page Layout Review Tell me what you want to do File Home Insert Formulas Data View PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Update now UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. B42 The expected cash collections from sales for the third quarter G H K M O Q R N A 20% d. The company desires to keep a finished goods inventory equal to 20 % of the following month's sales. The June ending inventory will meet this requirement. 24 e. Each table cloth requires 6 feet a special linen, can be hard to source t times. The company requires that the ending inventory of linen be equal to 60 % of the following month's production needs. 60% Inventory on hand 30-Jun 26 95,000 feet 27 20 30-Sep feet 29 30 f. The linen costs $1.00 per foot. 1 31 Instructions 34 1. Calculate the budgeted sales, by month and in total, for th quarter. 35 July August September Quarter 36 Budgeted units sales Selling price per unit 37 Budgeted sales 38. 30 2. Calculate the net expected cash balances, by month and in total, for the quarter. The expected cash collections ttom sales for the third auarter: Problem 1 Problem 2 Ready x Brvanna t Assignment template [Protected View] Excel AC306 Unit Data Review View ?Tell me hat you want to do Page Layout Fomulas File Home Insert Enable Editing Be careful-files from the internet can contain viruses. Unless you need to edit, it's sofer to stay in Protected View. PROTECTED VIEW first we need to close some apps. Update now Updates for Office are ready to be installed, but UPDATES AVAILABLE f The direct materials budget for the third quarter: B62 M F G I A for the quarter. 2. Calculate the net expected cash balances, by month and in total, r the third quarter 4. The expected cash collections from sales t 43 July August September Quarter 44 45 Accounts receivable, June 30: 46 July sales: 47 August sales 48 September sales: 49 Total cash collections 50 51 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October, The production budget (quantity beach umbrellas) for July-October July August September October 53 Budgeted unit sales AGu uesireu urits on 54 ending finished goods 56 Total needs Less units of beginning ST finished goods inventory Required production in units 5a 59 60 Calculate the quantity of material (in feet) that needs to be purchased by month and in total. Also calculate the raw material purchases for each month. 61 The direct materials budget for the third quarter: 63 July August September October Problem 1 Problem Ready AC306 Unit 5 Assignment template [Protected View] Excel Br Formulas Data Review View Tell me what you want to do File Home Insert Page Layout Interne can contain viruses. Unless you nee to edit, it's safer to stay in Protected View Enable Editing PROTECTED VIEW Be careful files from the be installed, but first we need to close some apps. Update now UPDATES AVAILABLE Updates for Office are ready B77 G A 60 month and in total. Also calculate the raw material purchases for each month. Calculate the quantity of material (in feet) that needs to be purchased by 61 The direct materials budget for the third quarter 62 July August September October 63 Required production in units of finished goods Units 64 of raw materials needed per unit of finished goods needed to meet 65 66 production ending raw materials inventory 67 Total units of raw 68 materials needed Less units of beginning 69 raw materials inventory Units of raw materials to 70 be purchased 71 Unit cost of raw materials Cost of raw materials to be 72 purchased 73 74 75 76 77 Problem 1 Problem 2 Ready C AC306 Unit 5 Assignment template Protected View] Excel Bryanna Marie Hardy Page Layout Data Review View Tell me what you want to do File Home Insert Formulas PROTECTED VIEW can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Be cateful-files from the Internel Updates for Office are ready be installed, but first we need to close some apps. Update now UPDATES AVAILABLE F G H M N D A 1 Enter titles and accounts in the green cells 2 Enter Numbers. in the blue cells 3 Enter your Calculations in the yellovi cells 4 Company manufactures table cloths. a. The Marketing Department has 5 The company is in the process developing next quarter's budgets and has gathered the following information for the budget preparation: Dallas estimated sales follows for the remainder of the year (in units): 6 7 July 25.000 October 20.000 August 40.000 November 25,000 September 39.000 December 37.500 11 . The selling price. 25 per unit 13 b. All sales are on account. Based on past experience, sales are collected in the following pattern: 17 25% in the month of sale 70% in the month following sale 5% uncollectible c. Sales for June totaled $525.000. 525000 31 goods inventory equal to 20 % the following month's sales. The June ending inventory will meet this requirement. d. The company desires to keep a finished Problem 1 Problem 2 Ready x B6 2013 AC306 Unit 5 Assignment template [Protected View) Excel Bryanna Marie Hardy G Page Layout Review Tell me what you want to do File Home Insert Formulas Data View PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Update now UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. B42 The expected cash collections from sales for the third quarter G H K M O Q R N A 20% d. The company desires to keep a finished goods inventory equal to 20 % of the following month's sales. The June ending inventory will meet this requirement. 24 e. Each table cloth requires 6 feet a special linen, can be hard to source t times. The company requires that the ending inventory of linen be equal to 60 % of the following month's production needs. 60% Inventory on hand 30-Jun 26 95,000 feet 27 20 30-Sep feet 29 30 f. The linen costs $1.00 per foot. 1 31 Instructions 34 1. Calculate the budgeted sales, by month and in total, for th quarter. 35 July August September Quarter 36 Budgeted units sales Selling price per unit 37 Budgeted sales 38. 30 2. Calculate the net expected cash balances, by month and in total, for the quarter. The expected cash collections ttom sales for the third auarter: Problem 1 Problem 2 Ready x Brvanna t Assignment template [Protected View] Excel AC306 Unit Data Review View ?Tell me hat you want to do Page Layout Fomulas File Home Insert Enable Editing Be careful-files from the internet can contain viruses. Unless you need to edit, it's sofer to stay in Protected View. PROTECTED VIEW first we need to close some apps. Update now Updates for Office are ready to be installed, but UPDATES AVAILABLE f The direct materials budget for the third quarter: B62 M F G I A for the quarter. 2. Calculate the net expected cash balances, by month and in total, r the third quarter 4. The expected cash collections from sales t 43 July August September Quarter 44 45 Accounts receivable, June 30: 46 July sales: 47 August sales 48 September sales: 49 Total cash collections 50 51 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October, The production budget (quantity beach umbrellas) for July-October July August September October 53 Budgeted unit sales AGu uesireu urits on 54 ending finished goods 56 Total needs Less units of beginning ST finished goods inventory Required production in units 5a 59 60 Calculate the quantity of material (in feet) that needs to be purchased by month and in total. Also calculate the raw material purchases for each month. 61 The direct materials budget for the third quarter: 63 July August September October Problem 1 Problem Ready AC306 Unit 5 Assignment template [Protected View] Excel Br Formulas Data Review View Tell me what you want to do File Home Insert Page Layout Interne can contain viruses. Unless you nee to edit, it's safer to stay in Protected View Enable Editing PROTECTED VIEW Be careful files from the be installed, but first we need to close some apps. Update now UPDATES AVAILABLE Updates for Office are ready B77 G A 60 month and in total. Also calculate the raw material purchases for each month. Calculate the quantity of material (in feet) that needs to be purchased by 61 The direct materials budget for the third quarter 62 July August September October 63 Required production in units of finished goods Units 64 of raw materials needed per unit of finished goods needed to meet 65 66 production ending raw materials inventory 67 Total units of raw 68 materials needed Less units of beginning 69 raw materials inventory Units of raw materials to 70 be purchased 71 Unit cost of raw materials Cost of raw materials to be 72 purchased 73 74 75 76 77 Problem 1 Problem 2 Ready