Question

Given the six-month merchandise budget below, answer questions #5-8.  When completing the budget, do not round to...

Given the six-month merchandise budget below, answer questions #5-8.  When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents).

8. What is the “Total $ Planned Purchases at Cost” figure?

Last Year’s Total Sales = $790,000

Planned % Sales Increase = 6%

Planned % Reductions = 18%

Planned EOM for Period = $196,500

Planned IMU%= 55%

                                                               

Six-Month Merchandise Budget

Fall/Winter

August

September

October

November

December

January

Totals

Planned Sales

Planned Sales %    

12%

14%

22%

22%

16%

14%

100%  

Planned BOM Stock

____________

Planned S/S Ratio

2.0

2.3

2.8

2.5

2.5

2.0

____________

Planned EOM Stock

____________

Planned Reductions

Planned Reductions %

16%

17%

18%

17%

15%

17%

100%  

Planned Purchases @ Retail

Planned Purchases @ Cost
A.

983,656
B.

$623,097
C.

$442,645.20
D.

Planned Purchases at Cost= Planned Purchases at Retail x (100% - Initial Markup %)

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Soln : Please refer the table here :

Fall/Winter August September October November December January Totals
Planned Sales 50244 58618 92114 92114 66992 58618 418700
Planned Sales %     12% 14% 22% 22% 16% 14% 100%  
Planned BOM Stock 100488 134821.4 257919.2 230285 167480 117236 1008229.6
Planned S/S Ratio 2 2.3 2.8 2.5 2.5 2 ____________
Planned EOM Stock 196500 196500 196500 196500 196500 196500 1179000
Planned Reductions 8039.04 9965.06 16580.52 15659.38 10048.8 9965.06 70257.86
Planned Reductions % 16% 17% 18% 17% 15% 17% 100%  
Planned Purchases @ Retail 154295.04 130261.7 47275.32 73988.38 106060.8 147847.1 659728.26
Planned Purchases @ Cost 69432.768 58617.75 21273.89 33294.77 47727.36 66531.18 296877.717

Planned purchased @ cost = $296877.72

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Anne Cummins is in the process of developing the merchandise budget for the beachwear shop she...
Anne Cummins is in the process of developing the merchandise budget for the beachwear shop she is opening in Maui, Hawaii , next year. She has decided to use the basic stock method of merchandise budgeting. Planned sales for the first half of next year are $240,000, and this is divided as follows: February = 9 percent, March = 10 percent,, April = 15 percent, May = 21 percent, June = 22 percent, and July = 23 percent. Planned total...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March. All sales are on credit and it collects 20% of all sales in the...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March. All sales are on credit and it collects 20% of all sales in the...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 36 $150 $5,400 8 Purchase 72 180 12,960 11 Sale 48 500 24,000 30 Sale 30 500 15,000 May 8 Purchase 60 200 12,000 10 Sale 36 500 18,000 19 Sale 18 500 9,000 28 Purchase 60 220 13,200 June 5 Sale...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: a. Estimated sales of King and Prince chairs for February by sales territory: Northern Domestic:   King 610 units at $780 per unit   Prince 750 units at $550 per unit Southern Domestic:   King 340 units at...
Purchase- Related Transaction The Stationery Company purchased merchandise on account from a supplier for $17,000 terms...
Purchase- Related Transaction The Stationery Company purchased merchandise on account from a supplier for $17,000 terms 2/10 n/30. The Stationery Company returned merchandise with invoice amount of $2, 200 and received full credit. a) If The Stationery Company pays invoice within the discount period, what is the amount of cash required for the payment? $____________. Determining Amounts to be Paid on Invoices Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit...
Required information [The following information applies to the questions displayed below.] Santana Rey created Business Solutions...
Required information [The following information applies to the questions displayed below.] Santana Rey created Business Solutions on October 1, 2019. The company has been successful, and its list of customers has grown. To accommodate the growth, the accounting system is modified to set up separate accounts for each customer. The following chart of accounts includes the account number used for each account and any balance as of December 31, 2019. Santana Rey decided to add a fourth digit with a...
[The following information applies to the questions displayed below.] Santana Rey created Business Solutions on October...
[The following information applies to the questions displayed below.] Santana Rey created Business Solutions on October 1, 2017. The company has been successful, and its list of customers has grown. To accommodate the growth, the accounting system is modified to set up separate accounts for each customer. The following chart of accounts includes the account number used for each account and any balance as of December 31, 2017. Santana Rey decided to add a fourth digit with a decimal point...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the new accounting period. All real accounts are closed but not the nominal accounts. All balance sheet accounts are closed. All temporary accounts are closed but not the permanent accounts. All permanent accounts are closed but not the nominal accounts. 4.A wholesaler is an intermediary that buys products from manufacturers or other wholesalers and sells them to consumers.Immersive Reader (1 Point) True False 5.The Merchandise...
The 2013 balance sheet of the Captain Jet Inc. is attached. During 2014, the following events...
The 2013 balance sheet of the Captain Jet Inc. is attached. During 2014, the following events occurred. 1. On January 10, sell merchandise on account to Rayms $9,600 and Fischer $8,800. Terms 2/10, n/30. Freight $100 for each sale, F.O.B. shipping point. 2. On January 12, purchase merchandise on account from Zapfel $3,000 and Liotta $2,400. Terms 1/10, n/30. Freight $120 for each sale, F.O.B. destination. 3. Receive checks, $4,000 from Longhini and $2,000 from Hall, for sales on account...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT