Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: Cash in bank according to the general ledger $11,920
Cash according to the October 31, 20Y3, bank statement 14,570
Outstanding checks as of October 31, 20Y3 3,280
Bank service charge for October 40
Note receivable, including interest collected by bank in October 2,370 No deposits were in transit on October 31.
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Determine the amount of cash receipts stolen by the sales clerk.

Apharmaceutical packaging company (ppc) has decided to reorganize its processes into cells. the company has four different production operations, each requiring a unique piece of equipment. the names and functions of the four pieces of equipment are sort, count, place, and package. the company packages five different families of products (a, b, c, d, and e). the tables below indicate the demand (total units/day by product family), required operations, and operation cycle times for each product family. assume that any individual piece of equipment is available to operate 16 hours/day, but 2 hours (in total) are lost each day on each piece of equipment due to breaks and meetings when operators are not available to operate the equipment. how many minutes/day are available for production

Galwaysc electronics makes two products. model a requires component a and component c. model b requires component b and component c. new versions of both models are released each year with updated versions of all components. all components are sourced overseas, and abc contracts annually for a quantity of each component before seeing that year’s demand. components are only assembled into finished products once demand for each model is known. for the coming year, alwaysc’s purchasing manner has proposed ordering 500,000 units of component a, 630,000 of component b, and 1,000,000 units of component c. her boss has asked why she has recommended purchasing so much of components a and b when alwaysc will not have enough of component c to fully use all of the inventory of a and b. what factors might the purchasing manager cite to explain her recommended order? explain your reasoning.

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?