C Enter titles and mecounta in the green cells Exter Numbers in the blue call Enter your Calculationg in the yellow calls Dallas Company manufactures table clotha. The company is in the process of developing next quarter's budgets and has gathered the following Information for the budget preparation: The Marketing Department has estimated sales as follows for the maindar al the year On units: 25,000 Outcher 20 000 August 25 INK September December 37.500 Thi selling price. 25 per unit i. All wales are on soopunt. Based on past experience, sales are collected in the following pattern 25% in the month of sale 7tra In the mouch following sale 5% uncollectible Sales for June totaled $525,000. 505000 d. The company desires to keep a finished gooch inventory equal to 20% of the following month's sales The June ending inventory will meet the requirement. I. Each table doth requires 6 feet of a special linen, can be hard to source at times. The company requires that the ending inventory of linen be equal to book of the following month's production randi. brenntory oh henil feet The inen Rose $ 1.00 par lout.[ The linen costs $1.00 par foot. Instructions 1: 1. Calculate the budgeted sales, by month and in total, for the quarter. Charter Hadputed unity molen 1 2. Calculate the net expected cash balances, by month and in total, for the quarter. The ripcurl cash collectings frompalmitor the third quarter 3. Calculate the estimated quantity of beach umbrellaa that need to be produced In July, August, September, and October.AcJob Und J Angprimi templin Protectors Viral ! Lice T 4. Calculate the quantity of material (In feet) that needs to be purchased by month and in total, Ano calculate the raw material purchases fer such month. +Home From.ba Help H Enter titles and accounts in the green cells Enter Numbers In the blue cells Enter your Calculations in the yellow cells a Flexible Budgets Sam the Sales Manager is confused with his review of the budget to actual report from last month. Sam felt he aveended his goals and did not upand all of hi budget, but the report is showing negative numbers. Budget Actual wariomen 1 Sales in units 120,8001 It Variable Expenses 14 Sales commissions 5,600 6:000 id Marketing capange 12,000 13,500 1,530 15 Travel expense 7,900 9,200 (1, 480) 1.500 400 DOC'EE (2,800] ap Flood Lipsnaan 1.500 1,500 31. Salan Salaries 1,200 we Admin sapenina Depreciat an tales auto 500 IN Total Hand soils 400019 Fixed Lepensor 20 Rent 1400 1 500 21 Sales Salaries 1,200 1.200 23 Admin expenses 21 Depreciation sales -autos 500 500 24 Total Fond corta 4.00 Total copenpes LT Required Reformat the budget report ining the flexible budget then cummerize the Sales activity for last month below. step 4- Determine stop 1 step 2 untp 3 Favorable make par uni cal budget at delmal budget -actual Unloveable Al per unit (B) Org Budget ()Actual E)Difference F/U Bales in units 80,000 100,000 190 000 Variable expenses ze Total Variable expenses as Fried expenses