i have all the data from the word document and the excel sheet can you plz put the fromulas in excel when your done! thank you

AaBbcode Abbede AaBbCcD No Spacing Heading 1 months are projected to be: LIN produces horse bridles. January B The following information pertains to the budget assumptions. & Finished goods inventory on January 1 is expected to be 5000 units. The desired ending FGI for any month (except for the Dec 31 inventory as noted previously) is expected to be 15% of the following month's sales. b. Data for materials used are: Part AB7 parts per unit $5.50 per part Part D33 3 parts per unit $4.50 per part Raw materials ending inventory is always budgeted to equal 20% of the following month's production needs. On March 31, the ending inventory of AB7 is expected to be 40,000 parts and for 33 is expected to be 30,000 parts Payments for Raw materials purchases are on 20% paid in the month of purchase and 80% in the month following purchase Accounts payable as of January 1 is $0.00 Direct labor used per harness 5 Red bortion per month VaRaNecati DLH 12500 Sube Depreciation 300 SC Selling and Admin is estimated each to be Commissions Deprecation & Selling price per harness is $110.00 h. Sales are all on account of sales are collected in the month of sale and 6 in the month following the sale, Accounts receivable on January 1 is $40.000 February is a planned purchase of equipment for 5237,500 | Borrowings are at per year interest, and borrowings are assumed to be at the beginning of the month required and at the end of the month of repayment, January 1 beginning cash is $20,000. Interest on borrowing is paid before any principal can be paid. To the extent possible, the company strives to repay any debt at the end of each month if there is cash available. Minimum cash balance at the end of any month is $10,000 REQUIRED: Please prepare the following budgets in an Excel spreadsheet for each month of the first quarter and for the quarter in total. The first five flichtgreen highlighted) budgets are to be on one tab, separate from the original data, and the two light blue Highlighted) budgets are to be on a third, separate, tab. All budgets should be formulae and cell references there should be no Values directly keyed in 1 Sales budget Direct labor budget 2. Production budget 5. Overhead budget 3. Direct materials purchases budget 6. Selling and Admin budget 7. Cash Budget Income Statement Home Insert View Draw Page Layout Calibri (Body} 11 Formulas A Data Review == General Merge & Crew $ % 5 Conde G1 + x 4 5 1 Las data 3 SALES INFORMATION 4 Projected sales in units January February march 15000 18000 21000 24000 26000 April Selling price of each harness nished product output) 110 dollars 13 Collections predition 14 collected in month of sale 15 collected in subsequent month Accounts receivable as at January 1 35% of current month sales 65% of prior month sales 18 PRODUCTION INFORMATION 19 Standard production predictions Finished good inventory, lan 1 Finished Goods Inventory policy Desired ending FG 15 percent of next months sales volume Direct materials usage quantity per unit of ourput per harness) 4 price per quantity unit S.S dollars 4.5 dollar 033 Raw Materials inventory policy Desire dinding Raw Materials inventory Actual beginning M antan 1) is content with this policy ASSUME ENDING INVENTORY OF AB7 AT END OF MARCH EQUALS 20 percent of following month's production needs 40000 QUANTITIES Sheet me Insert Review View Draw Page Layout Calibri (Bechy) 11 Formulas . A A Data = We That General 20 percent of following months product e d Raw Materials inventory policy Desire dending Raw Materials inventory Actual beginning RM on Jan 1) is consistent with this policy ASSUME ENDING INVENTORY OF ART AT END OF MARCH QUALS ASSUME ENDING INVENTORY OF 33 AT END OF MARCH QUALS Payment for OM purchases 80 percent of purchased Inventory are paid for in the month following purchase 20 percent of purchased Inventory are paid for in the month of purchase Accounts payable satanuary 1 40000 QUANTITIES 30000 QUANTITIES Direct labor each hamness takes wage rate for direct laboris 1.5 hours of direct labor 15 dollars per hour d portioner month variable costi per DLH cost driver' Supplies ADDITIONAL INFORMATION Selling and admin per month variable costs per unit sold cost driver portion per month 30000 Salaries Depreciation Shipping 13000 Sheet1 Sheet2 Home went or Page Layout Formulas Duo Rosten View AaBbcode Abbede AaBbCcD No Spacing Heading 1 months are projected to be: LIN produces horse bridles. January B The following information pertains to the budget assumptions. & Finished goods inventory on January 1 is expected to be 5000 units. The desired ending FGI for any month (except for the Dec 31 inventory as noted previously) is expected to be 15% of the following month's sales. b. Data for materials used are: Part AB7 parts per unit $5.50 per part Part D33 3 parts per unit $4.50 per part Raw materials ending inventory is always budgeted to equal 20% of the following month's production needs. On March 31, the ending inventory of AB7 is expected to be 40,000 parts and for 33 is expected to be 30,000 parts Payments for Raw materials purchases are on 20% paid in the month of purchase and 80% in the month following purchase Accounts payable as of January 1 is $0.00 Direct labor used per harness 5 Red bortion per month VaRaNecati DLH 12500 Sube Depreciation 300 SC Selling and Admin is estimated each to be Commissions Deprecation & Selling price per harness is $110.00 h. Sales are all on account of sales are collected in the month of sale and 6 in the month following the sale, Accounts receivable on January 1 is $40.000 February is a planned purchase of equipment for 5237,500 | Borrowings are at per year interest, and borrowings are assumed to be at the beginning of the month required and at the end of the month of repayment, January 1 beginning cash is $20,000. Interest on borrowing is paid before any principal can be paid. To the extent possible, the company strives to repay any debt at the end of each month if there is cash available. Minimum cash balance at the end of any month is $10,000 REQUIRED: Please prepare the following budgets in an Excel spreadsheet for each month of the first quarter and for the quarter in total. The first five flichtgreen highlighted) budgets are to be on one tab, separate from the original data, and the two light blue Highlighted) budgets are to be on a third, separate, tab. All budgets should be formulae and cell references there should be no Values directly keyed in 1 Sales budget Direct labor budget 2. Production budget 5. Overhead budget 3. Direct materials purchases budget 6. Selling and Admin budget 7. Cash Budget Income Statement Home Insert View Draw Page Layout Calibri (Body} 11 Formulas A Data Review == General Merge & Crew $ % 5 Conde G1 + x 4 5 1 Las data 3 SALES INFORMATION 4 Projected sales in units January February march 15000 18000 21000 24000 26000 April Selling price of each harness nished product output) 110 dollars 13 Collections predition 14 collected in month of sale 15 collected in subsequent month Accounts receivable as at January 1 35% of current month sales 65% of prior month sales 18 PRODUCTION INFORMATION 19 Standard production predictions Finished good inventory, lan 1 Finished Goods Inventory policy Desired ending FG 15 percent of next months sales volume Direct materials usage quantity per unit of ourput per harness) 4 price per quantity unit S.S dollars 4.5 dollar 033 Raw Materials inventory policy Desire dinding Raw Materials inventory Actual beginning M antan 1) is content with this policy ASSUME ENDING INVENTORY OF AB7 AT END OF MARCH EQUALS 20 percent of following month's production needs 40000 QUANTITIES Sheet me Insert Review View Draw Page Layout Calibri (Bechy) 11 Formulas . A A Data = We That General 20 percent of following months product e d Raw Materials inventory policy Desire dending Raw Materials inventory Actual beginning RM on Jan 1) is consistent with this policy ASSUME ENDING INVENTORY OF ART AT END OF MARCH QUALS ASSUME ENDING INVENTORY OF 33 AT END OF MARCH QUALS Payment for OM purchases 80 percent of purchased Inventory are paid for in the month following purchase 20 percent of purchased Inventory are paid for in the month of purchase Accounts payable satanuary 1 40000 QUANTITIES 30000 QUANTITIES Direct labor each hamness takes wage rate for direct laboris 1.5 hours of direct labor 15 dollars per hour d portioner month variable costi per DLH cost driver' Supplies ADDITIONAL INFORMATION Selling and admin per month variable costs per unit sold cost driver portion per month 30000 Salaries Depreciation Shipping 13000 Sheet1 Sheet2 Home went or Page Layout Formulas Duo Rosten View