Question

I need help finding the numbers for the empty boxes. Can someone help me out? Thank you.
Crane Processing Company performs word-processing services for business clients and students in a university community. The work for business clients is fairly steady throughout the year. The work for students peaks significantly in December and May as a result of term papers, research project reports, and dissertations. Two years ago, the company attempted to meet the peak demand by hiring part-time help. This led to numerous errors and much customer dissatisfaction. A year ago, the company hired four experienced employees on a permanent basis in place of part-time help. This proved to be much better in terms of productivity and customer satisfaction. But, it has caused an increase in annual payroll costs and a significant decline in annual net income. Recently, Melissa Braun, a sales representative of Banister Services Inc., has made a proposal to the company. Under her plan, Banister will provide up to four experienced workers at a daily rate of $86 per person for an 8-hour workday. Banister workers are not available on an hourly basis. Crane would have to pay only the daily rate for the workers used. The owner of Crane Processing, Carol Holt, asks you, as the company's accountant, to prepare a report on the expenses that are pertinent to the decision. If the Banister plan is adopted, Carol will terminate the employment of two permanent employees and will keep two permanent employees. At the moment, each employee earns an annual income of $21,500. Crane pays 7.65% FICA taxes, 0.80% federal unemployment taxes, and 5.40% state unemployment taxes. The unemployment taxes apply to only the first $8,000 of gross earnings. In addition, Crane pays $30 per month for each employee for medical and dental insurance. Carol indicates that if the Banister Services plan is accepted, her needs for temporary workers will be as follows. Number of Employees Working Days per Month Months January-March April-May June-October November-December NM NM Answer the following.

Answer 1

Con = New Microsoft Office Excel Worksheet - Microsoft Excel - 0 X Insert Page Layout Formulas Data Review View Home Cut Eg Copy Calibri B I = = = E D B Wrap Text Merge & Center Accounting % , Fill Paste in U E to 09 Cell Styles Insert Delete Format Conditional Format Formatting as Table Styles Clear - 11 - A A - A Font foc =B9-C19 B Z Ft Sort & Find & Filter Select Editing Alignment Number Clipboard C21 Cells A C D E F G I J K L M N O P Q 1 2 (a) Banister services inc 3 months 4 January - march 5 april-may 6 june - October 7 november - december Cost * 11,352.00 13,932.00 * 17,200.00 * 12,900.00 9 *55,384.00 10 *43,000.00 11 permanenet employees 12 Salaries 13 additional payroll costs 14 fica taxes 15 federal unemployment taxes 16 state unemployement taxes 17 medical and dental insurance 18 19 20 21 crane processing compny would save * 3,289.50 * 128.00 * 864.00 * 720.00 * 5,001.50 * 48,001.50 * 7,382.50 22 23 24 25 H S heets Sheet4 Sheet1 Sheet2 Sheet3 Ready + Type here to search o e @ OU 100% 0 uc 15:50 ^ a ») ENG21 29-02-20206 9