1. After careful analysis of the economic data from the U. S. Government the XYZ
ID: 2727740 • Letter: 1
Question
1. After careful analysis of the economic data from the U. S. Government the XYZ store set a sales plan increase for the next season (Feb.- July) of 8.2%. Based on this year's sales plan what is the companies new projected sales plan for the next season?
2. In the prior year same sales period the XYZ store had actual sales of $1,850,000.00. What was the increase/decrease for the sales period and suggest reasons for the change from one season to the next.
Mark Shorta EOM DOM Total Monthly Planned Open to Mark ges Stock Stock Needs Planned sal On Order E Down Needs purchases | buy |down % 0.02 0.03 0.0414000 0 0.05 0.07 3 Feb. 300000 4 Mar. 200000 80000.022000000 B3+F3 B3+G3 13-H3 J3-C3E3/B3 |12000|0.04 |80000|40000-84+F4*84+64|=14-H4-4-C41=E4/84 125000 30000 150000 100000 -5-C51=E5/B5 |60000-86+F6"BG+G6 |=16-H6-6-C61=E6/B6 |0.05 |0.07 |0.02 |0.03 |110000|900001-85+F5"B5+65-5-H5 |90000 21000011500001-874F7"B7+67 |=17-H7-17-C7 |70000 | 30000 |-88+F8"B8+68|=18-HB -8-C8 5 Apr. 300000 |3000 |18000 25000 -E6/55 -E7197 -E8/BB 6 May 6 May 200000 16-C6 7 June 400000 8 July 200000 9 Average AVERAGE(B3:B8) AVERAGE(C3:C8) 30000 AVG monthly sales AVG monthly on order 10Explanation / Answer
1)It was given that company is expecting the next season sales to be 8.2% high,the present season planned sale are total $1,600,000 and for next season it is (1+8.2%)*1,600,000=$1,731,200
2)If prior year sales is $1,850,000 and decrease amount is ($1850000-1600000)=$250,000 ans the reason in economic downturn and the higher unemployment rate
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.