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