Question (a):IfHong Konghad no minimumproduction quantity requirement, how many units of each of the 10 styles of Women's parka would you order as part of your first production lot size of 10,000 units? Use Excel formulas to answer this question. (3 points)

Question (b): Since Hong Kong does have a minimum production requirement of 600 units for each style, how many units of each of the 10 styles would you order as part of your production lot size of 10,000 units? Use Excel formulas to answer this questions.(6 points)

*Note: please show the excel formulas

Exhibit 10 Sample Buying Committee Forecasts, 10 Styles of Women's Parkas Individual Forecasts Average Standard 2 x Std. Forecast Style Pricea Deviation Deviation Laura Carolyn Greg Wendy Tom Wally Gail $110 900 1,000 900 1,300 800 1,200 1,017 194 388 Isis $90 800 700 1,000 1,600 950 1,200 1,042 323 646 Entice $80 1,200 1,600 1,500 1,550 950 1,350 1,358 248 496 Assault $90 2,500 1,900 2,700 2,450 2,800 2,800 2,525 340 680 Teri $123 800 900 1,000 1,100 950 1,850 1,100 381 762 Electra $173 2,500 1,900 1,900 2,800 1,800 2,000 2,150 404 807 Stephanie $133 600 900 1,000 1,100 950 2,125 1,113 524 1,048 Seduced $73 4,600 4,300 3,900 4,000 4,300 3,000 4,017 556 1,113 Anita $93 4,400 3,300 3,500 1,500 4,200 2,875 3,296 1,047 2,094 Daphne $148 1,700 3,500 2,600 2,600 2,300 1,600 2,383 697 1,394 Totals 20,000 20,000 20,000 20,000 20,000 20,000 20,000 aObermeyer's wholesale price Notes Laura Kornashiewicz was marketing director Wendy Hemphill was production coordinator Carolyn Gray was customer service manager Tom Tweed was a sales representative Greg Hunter was production manager Wally Obermeyer was vice president