Icementrics is a subcontract manufacturer that produces prototype products for

Icementrics is a subcontract manufacturer that produces prototype products for organizations that may possibly want Icementrics to later manufacture their products for them.
Icementrics has a R & D division and a manufacturing division. The R & D division performs research and develops prototype products for companies for a consulting fee. The manufacturing division manufactures products for companies and charges a fee per unit of product produced.

Research different Midmarket accounting systems and make a recommendation to Icementrics on whether to stay with Quickbooks or implement a new software system.
A: Write a business report summarizing the following:
1. Background—Existing system and reason for change

2. Discussion—Including answers to questions

3. Software system recommendation and justification for the system selected

4. Provide one software product not recommending and reasons for not recommending
B: Additional Discussion Questions:
Questions your client (Icementrics) asks during the discovery stage that should be addressed in your final report.

1. Will we need to change business processes when we replace Quickbooks?

2. Should we fully automate everything or will there still be some manual processes?

3. Our CFO wants the system to fully integrate across business processes. Will this system do this? Are there any business processes that will not integrate? If so, what and why not?

4. Would our company benefit from using cloud computing rather than client server computing?

5. Can you provide examples of how our new system will reduce costs, time, and errors?

Following is a sales order form for Winter’s World of

Following is a sales order form for Winter’s World of Wines, Inc. This form is prepared manually by a sales clerk and based on a telephone order from a customer. This form represents the source document that triggers the revenue process at Winter’s World of Wines.

Required:

Use Microsoft Excel to perform the following:

a. Design an appropriate format for a data entry screen that could be used in the accounting department to enter information from the sales order in the company’s revenues software program.

b. Prepare a sales journal with appropriate column headings. Enter the relevant information from the preceding sales order into your spreadsheet.

Austin Bar Supply manufactures equipment for bars and lounges. While

Austin Bar Supply manufactures equipment for bars and lounges. While the company manufactures several different products, one is a blender that bartenders use to make certain kinds of drinks. From the textbook website at http://www.wiley.com/college/turner, download the spreadsheet template named requisition.xls. Using information in the spreadsheet template, complete the requisition form to calculate the quantity and cost of the parts needed to manufacture a batch of 500 bar blenders. To look up the cost from the price list sheet, you will use a spreadsheet function called VLOOKUP. Be sure to design your formulas in a way that will incorporate changes in the batch size or changes to costs of individual parts.

Following is a time sheet completed by an hourly wage

Following is a time sheet completed by an hourly wage earner at Harold, Inc.:

Use Microsoft Excel to perform the following tasks:

a. Design an appropriate format for a data entry screen that could be used in the payroll department to enter information from this time sheet in the company’s payroll software program.

b. Prepare a payroll journal with the column headings shown in the table above. Enter the relevant information from the preceding time sheet onto this journal and calculate gross pay, federal withholdings, and net pay. Use two lines for this employee, and assume that the pay rate is $19.75 per hour, with time‐and‐a‐half for overtime. (Overtime applies to any time worked over 40 hours within one week.) Use the following withholding rates: FICA (Social Security)—6.2 percent of gross pay; Medicare—1.45 percent of gross pay; federal income taxes—20 percent. Assume no additional withholdings.