Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

March Var% Bud Last Year STORE 999 MARCH Profit & Loss Actual Budget Var% LY Y-T-D (January, February, March) Actual Budget Var% Bud Last Year

image text in transcribedimage text in transcribed

March Var% Bud Last Year STORE 999 MARCH Profit & Loss Actual Budget Var% LY Y-T-D (January, February, March) Actual Budget Var% Bud Last Year Var% LY $794,973 $846,259 -6.06% $804,731 -1.21% $505,773 $465,810 8.58% $470,018 7.61% $332,938 -2.00% $317,857 4.74% Pharmacy (Rx) Sales Front Store (FS) Sales $339,748 $175,062 In examining your store's year-to- date results, what would you target as your greatest opportunity for improvement? $192.250 9.82% $180,657 6.42% TOTAL SALES $525,188 $514,810 2.02% $498,514 5.35% $1,300,746 $1,312,769 -0.86% $1,274,749 2.04% Rx Costs of Goods Sold $203,525 0.34% $193,453 -4.85% $529,431 0.98% $521,673 -1.49% Reducing Pharmacy Markdowns $202,835 $68,445 $534,676 $154,916 Rx Markdowns $60,994 -12.22% $56,392 -21.37% $152,590 1.50% $151,503 -0.72% Rx Shrink $600 $641 6.40% $1,187 $1,634 27.36% $1,543 23.07% Increasing Sales in the Pharmacy TOTAL Rx MARGIN $61,058 $74,588 -18.14% $68,012 -10.22% $111,765 $155,033 -27.91% $130,012 - 14.03% Better aligning Wages with Budget FS Costs of Goods Sold $110,957 -3.75% 1.42% $283,906 $281,250 -0.94% 3.41% $106,942 $19,336 $112,557 $22,137 $293,915 $72,788 FS Markdowns $18,948 2.01% 14.41% $58,622 $61,885 5.27% 19.46% Reducing Front Store Shrink FS Shrink $3,946 $3,435 -14.88% $3,673 -7.43% $9,171 $9,141 -0.33% $12,985 29.37% TOTAL FS MARGIN $58,399 $45,349 28.78% $42,290 38.09% $154,074 $113,534 35.71% $90,330 70.57% Increasing Sales in the Front Store TOTAL GROSS MARGIN $119,457 $119,937 -0.40% $110,302 8.30% $265,839 $268,567 -1.02% $220,342 20.65% $27,058 $26,547 -1.92% $24,651 -9.76% $70,630 $69,148 -2.14% $64,581 -9.37% $92 $250 63.20% $211 $1,062 80.13% Rx Regular Wages Rx Overtime Wages FS Regular Wages FS Overtime Wages Employee Benefits $19,277 -6.76% $17,560 -17.20% $51,402 $50, 131 -2.54% $46,179 -11.31% $20,581 $179 $498 64.06% $353 $950 62.84% $9,491 $10,017 5.25% $8,669 -9.48% $27,385 $28,223 2.97% $24,296 -12.71% TOTAL PAYROLL & BENEFITS COSTS $57,401 $55,841 -2.79% $51,628 -11.18% $149,981 $147,502 -1.68% $137,068 -9.42% MANAGEMENT CONTROLLED PROFIT $62,056 $64,096 -3.18% $58,674 5.76% $115,858 $121,065 -4.30% $83,274 39.13% March Var% Bud Last Year STORE 999 MARCH Profit & Loss Actual Budget Var% LY Y-T-D (January, February, March) Actual Budget Var% Bud Last Year Var% LY $794,973 $846,259 -6.06% $804,731 -1.21% $505,773 $465,810 8.58% $470,018 7.61% Which of the following statements is true regarding your store's Pharmacy sales? -2.00% 4.74% Pharmacy (Rx) Sales Front Store (FS) Sales TOTAL SALES $332,938 $192,250 $339,748 $175,062 $317,857 $180,657 9.82% 6.42% $525,188 $514,810 2.02% $498,514 5.35% $1,300,746 $1,312,769 -0.86% $1,274,749 2.04% Rx Costs of Goods Sold 0.34% $193,453 -4.85% $529,431 $534,676 0.98% $521,673 -1.49% $202,835 $203,525 $68,445 $60,994 Budgeted numbers for the year represent about a 5% increase from last year Rx Markdowns -12.22% $56,392 -21.37% 1.50% $151,503 -0.72% $152,590 $1,187 $154,916 $1,634 Rx Shrink $600 $641 6.40% 27.36% $1,543 23.07% TOTAL Rx MARGIN $61,058 $74,588 -18.14% $68,012 -10.22% $111,765 $155,033 -27.91% $130,012 -14.03% For the year, they account for less than 60% of Total Sales FS Costs of Goods Sold $106,942 -3.75% $112,557 1.42% $281,250 -0.94% $293,915 3.41% FS Markdowns $110,957 $18,948 $3,946 $19,336 2.01% 14.41% $283,906 $58,622 $9,171 $61,885 5.27% $22,137 $3,673 19.46% $72,788 $12,985 For March, they were worse than last year's results FS Shrink $3,435 -14.88% -7.43% $9,141 -0.33% 29.37% TOTAL FS MARGIN $58,399 $45,349 28.78% $42,290 38.09% $154,074 $113,534 35.71% $90,330 70.57% For the year, you are ahead of last year's results TOTAL GROSS MARGIN $119,457 $119,937 -0.40% $110,302 8.30% $265,839 $268,567 -1.02% $220,342 20.65% $27,058 $26,547 -1.92% $24,651 -9.76% $70,630 $69,148 -2.14% $64,581 -9.37% $92 $250 63.20% 80.13% For the year, you are on track to exceed your budget $1,062 $46,179 $20,581 $19,277 -6.76% $17,560 -17.20% $211 $51,402 $353 $50,131 -2.54% Rx Regular Wages Rx Overtime Wages FS Regular Wages FS Overtime Wages Employee Benefits TOTAL PAYROLL & BENEFITS COSTS -11.31% $179 $498 64.06% $950 62.84% $9,491 $10,017 5.25% $8,669 -9.48% $27,385 $28,223 2.97% $24,296 -12.71% $57,401 $55,841 -2.79% $51,628 -11.18% $149,981 $147,502 -1.68% $137,068 -9.42% MANAGEMENT CONTROLLED PROFIT $62,056 $64,096 -3.18% $58,674 5.76% $115,858 $121,065 -4.30% $83,274 39.13%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: David Perkins

4th Edition

111925700X, 978-1119257004

More Books

Students also viewed these Accounting questions

Question

The main elements of a purchase contract.

Answered: 1 week ago

Question

4. Explain the strengths and weaknesses of each approach.

Answered: 1 week ago

Question

3. Identify the methods used within each of the three approaches.

Answered: 1 week ago