Problem 6- Needs to be on an excel spreadsheet - Accounting Majors ONLY

CASE 6.2

A Cost-Benefit Analysis

Village Hardware is a retail store selling hardware, small appliances, and sporting goods. The business follows a policy of selling all merchandise at exactly twice the amount of its cost to the store and uses a periodic inventory system.

At year-end, the following information is taken from the accounting records:

A physical count indicates merchandise costing $49,300 is on hand at December 31.

Instructions

1. Prepare a partial income statement showing computation of the gross profit for the year.
2. On seeing your income statement, the owner of the store makes the following comment: “Inventory shrinkage losses are really costing me. If it weren't for shrinkage losses, the store's gross profit would be 50 percent of net sales. I'm going to hire a security guard and put an end to shoplifting once and for all.”

Determine the amount of loss from inventory shrinkage stated (1) at cost and (2) at retail sales value. (Hint: Without any shrinkage losses, the cost of goods sold and the amount of gross profit would each amount to 50 percent of net sales.)

1. Assume that Village Hardware could virtually eliminate shoplifting by hiring a security guard at a cost of $1,800 per month. Would this strategy be profitable? Explain your reasoning.