1. From the budget plan and resale cost budget plan, How the company do evaluate and measure performance of both plan in the end of the year? (in excel)?
   

INVENTORY BUDGET QTY Price Value RESALE COST BUDGET QTY Price Value 1 Protein & Fitness 10,000 $ 15.00 $ 150,000.00 1 Protein & Fitness 10,000 $ 30.00 S 300,000.00 2 Vitamins 10,000 20.00 S 200,000.00 2 Vitamins 10,000 $ 30.00 S 300,000.00 3 Healthy Weight 10,000 25.00 S 250,000.00 3 Healthy Weight 10,000 $ 38.00 S 380,000.00 4 Superfoods& Groceries 10,000 30.00 300,000.00 4 Superfoods& Groceries 10,000 $ 40.00 S 400,000.00 5 Herb& Natural Remedies 10,000 22.00 $ 220,000.00 5 Herb& Natural Remedies 10,000 $ 30.00 300,000.00 6 Natural Beauty & Skin 10,000 10.00 100,000.00 6 Natural Beauty & Skin 10,000 $ 20.00 S 200,000.00 7 Home & Lifestyle 10,000 S 6.00 $ 60,000.00 7 Home & Lifestyle 10,000 $ 15.00 S 150,000.00 TOTAL $ 1,280,000.00 TOTAL $ 2,030,000.00 Monday to Friday OPERATION HOURS 10am to 9PM LABOR BUDGET H Rate/Hr Value 1 Manager (owner ) 1,920 S 20.00 S 38,400.00 2 Clerk ( shipping receiving ) 1,920 S 20.00 S 38,400.00 3 Clerk ( restock ) 1,920 S 20.00 38,400.00 Cashier] 1,920 S 15.00 $ 28,800.00 5 Cashier2 1,920 $ 15.00 S 28,800.00 TOTAL $ 172,800.00 Gross Expenses total $ 1,571,600.00 OVERHEAD BUDGET QTY Price Value Profit S 458,400.00 1 Rent Retail with storage 12 $ 5,000.00 S 60,000.00 2 Utilities 12 800.00 9,600.00 3 Equipment 12 500.00 S 6,000.00 Insurance 12 $ 900.00 S 10,800.00 Advertisement 12 $ 1,200.00 14.400.00 6 Admin-Accountant 12 $ 1,500.00 S 18,000.00 TOTAL S 118,800.00