B C D E F A -fx General information: OPTIMA, INC. Selling price of bamboo rocking horses $33.50 Linear feet of bamboo required per rocking horse 3 Cost of bamboo per foot $2.00 Hours required to build 0.50 Average hourly direct labor rate $15.00 Additional information: C H Ending finished goods inventory (percentage of the next quarter's sales) Ending raw materials inventory (percentage of the next quarter's production) Variable manufacturing overhead rate per direct labor hour Estimated quarterly fixed manufacturing overhead Estimated monthly selling and administrative expenses: Variable Fixed 40% 30% Quarters/Year $8.00 $275,000.00 4 $6.00 $200,000.00 Expected number of frames sold in following quarters: 4th Quarter 2013 55,000 5 1st Quarter 2014 65,000 2nd Quarter 2014 70,000 3rd Quarter 2014 75,000 28 4th Quarter 2014 90,000 29 1st Quarter 2015 90,000 30 2nd Quarter 2015 75,000 31 32 Additional information: 33 Cash on hand at April 1 34 Percentage of sales in cash 35 36 37 + Percentage of credit sales collected during quarter of sale Percentage of credit sales collected in quarter following sale Percentage of direct material purchases paid in quarter purchased Instructions Given Budget $250,000 80% 50% 50% 80%