1.Create a spreadsheetcalled BA370 Spreadsheet Assignment. xlsxthat shows the names of the 10 employees in each department, their current salary, the difference between their current salary and the industry average salary for their department, and the percent their salary would need to be increased to meet the industry average. 2.In yourspreadsheet, compute the average increase needed to meet the industry average for each department and the average increase, company-wide, to meet industry averages.3.How can you use this analysis to contribute to the employee salary decision

Sodas in a can are supposed to contain an average of 12 ounces. this particular brand has a standard deviation of 0.1 ounces, with an average of 12.1 ounces. if the can's contents follow a normal distribution, what is the probability that the mean contents of a six pack are less than 12 ounces?

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?

The following account balances at the beginning of january were selected from the general ledger of fresh bagel manufacturing​ company: work in process inventory ​$0 raw materials inventory $ 29 comma 000 finished goods inventory $ 40 comma 900 additional​ data: 1. actual manufacturing overhead for january amounted to $ 62 comma 600. 2. total direct labor cost for january was $ 63 comma 600. 3. the predetermined manufacturing overhead rate is based on direct labor cost. the budget for the year called for $ 255 comma 000 of direct labor cost and $ 382 comma 500 of manufacturing overhead costs. 4. the only job unfinished on january 31 was job no.​ 151, for which total direct labor charges were $ 5 comma 700 ​(1 comma 000 direct labor​ hours) and total direct material charges were $ 14 comma 400. 5. cost of direct materials placed in production during january totaled $ 123 comma 300. there were no indirect material requisitions during january. 6. january 31 balance in raw materials inventory was $ 35 comma 200. 7. finished goods inventory balance on january 31 was $ 35 comma 400. what is the cost of goods manufactured for​ january