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).

7. What is the “Total $ Planned Purchases at Retail” 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.	$939,100
	B.	$442,645.20
	C.	$1,384,660
	D.	$983,656

Planned Purchases at Retail= Sales + Reductions + EOM – Planned BOM

Planned BOM Inventory= Planned Monthly Sales x Planned Monthly Stock-to-Sales Ratio

Solutions

Expert Solution

Solution:

I have explained the work done in the below excel.

Fall/Winter	Work Done and calculation	August	September	October	November	December	January	Totals
Planned Sales	6% increase in sales = 790,000 *1.06 = 837,400 and each month the percentage is provided.	100488	117236	184228	184228	133984	117236	837400
Planned Sales %	Percentage of sales each month	12%	14%	22%	22%	16%	14%	100%
Planned BOM Stock	BOM stock= Planned monthly * Planned monthly stock to sales ratio	200976	269643	515838	460570	334960	234472	2016459
Planned S/S Ratio	Stock to sales ratio	2	2.3	2.8	2.5	2.5	2
Planned EOM Stock	Total EOM stock given = 196500 * with the percentage of increase in sales	23580	27510	43230	43230	31440	27510	196500
Planned Reductions	Planned total reduction is given at 18%= 196500*.82	25780.8	27392.1	29003.4	27392.1	24169.5	27392.1	161130
Planned Reductions %	Reduction percentage monthly	16%	17%	18%	17%	15%	17%	100%
Planned Purchases @ Retail	Purchase @ retail = Sales +Reductions +EOM - Planned BOM	-51127	-97505	-259377	-205720	-145367	-62334	-821429.2

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round...

Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents) 4. What is the “Total $ Planned Purchases at Cost” figure? Last Year’s Total Sales = $100,000 Planned % Sales Increase = 5% Planned % Reductions = 14% Planned EOM for Period = $25,000 Planned IMU% for Period = 53% Six-Month Merchandise Budget Spring/Summer February March April May June July Totals...

Given this table. Answer the following questions in the box below. x 3 5 6 8...

Given this table. Answer the following questions in the box below. x 3 5 6 8 9 11 y 2 3 4 6 5 8 a) Find the Linear correlation Coefficient r. b) Is there a linear correlation between x & y? Explain your answer.

Questions 4-8 USE THE FOLLOWING INFORMATION TO ANSWER THE NEXT (5) QUESTIONS: Pitchfork, Inc. sold merchandise...

Questions 4-8 USE THE FOLLOWING INFORMATION TO ANSWER THE NEXT (5) QUESTIONS: Pitchfork, Inc. sold merchandise to Min Corporation on June 1, 2019 and accepted an interest-bearing note with an 8% APR. Min agreed to make annual payments of P&I in the amount of $27,000 per year for 5 years with the first payment being made immediately. The remaining payments are to be remitted each June 1st. Pitchfork’s year-end is December 31st. Min’s normal cost to borrow is 8%. Required:...

Exercise 8-11 Cash Budget Analysis [LO8-8] A cash budget, by quarters, is given below for a...

Exercise 8-11 Cash Budget Analysis [LO8-8] A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $6 Add collections from customers 96 323 Total cash...

As a buyer, consider when making decisions on preparing a six-month merchandise plan? Describe three sources.

Use the transactions below to answer the following questions. Round to the nearest cent for per...

Use the transactions below to answer the following questions. Round to the nearest cent for per unit cost and the nearest dollar for the totals for COGS, Ending Inventory and Gross Profit. Date Quantity Unit Cost Sale Price Mar 1 Beginning Inventory 30 $30 Mar 4 Purchase 40 $28 Mar 8 Sale 35 $54 Mar 15 Purchase 50 $26 Mar 20 Sale 42 $55 Using the LIFO Method for inventory costing calculate the following amounts for the month of March....

Read the passage given below, and answer the questions given at the end. Each answer must...

Read the passage given below, and answer the questions given at the end. Each answer must be within the word limit of 50-100 words. Passage: Students are responsible for familiarising themselves with the University Code of Student Conduct, as on enrollment with the University the student has placed themselves under the policies and regulations of the University and all of its duly constituted bodies. Disciplinary authority is exercised through the Student Conduct Committee. The Committee has procedures in place for...

For the matrix X answer the questions below. X = ( 4 8 8 ; 3...

For the matrix X answer the questions below. X = ( 4 8 8 ; 3 6 − 9 ), this is a 2x3 matrix (a) Calculate XX’ and compute the corresponding Eigen values and Eigen vectors. (b) Obtain the singular-value decomposition of the matrix X. Note that: Eigen values for X’X are: λ1 =150, λ2 = 120, and λ3 = 0. The corresponding Eigen vectors are: eigenvector1 = 1/√30 (1 2 5), eigenvector2 = 1/√6 (1 2 -1), and...

5. Read the following case and answer the questions given below: SAFTA: So close, yet so...

5. Read the following case and answer the questions given below: SAFTA: So close, yet so far The Tenth South Asia Economic Summit which was concluded in Kathmandu in November 2017 had underscored deepening economic integration in the region. It is free trade that drives the process of economic integration. It took more than two decades for South Asian countries to reach the initial phase of a free trade area (FTA). The regional FTA which took-off in the mid-1990s under...

5. Use the data set given below to answer these questions: (24 marks) Income 52.1 49.3...

5. Use the data set given below to answer these questions: Income 52.1 49.3 48.9 44.4 53.5 48.0 49.2 50.6 53.2 43.7 46.9 45.5 50.1 48.1 52.7 49.5 44.5 52.0 51.1 54.9 54.0 54.2 44.2 47.2 51.9 52.8 52.3 53.6 44.2 38.4 a. What is the sample mean of the variable Income? b. What is the sample median the variable Income? c. Find the range of Income. d. Find the sample standard deviation of Income. e. Compute the first and...

Subjects