Instructions: - This is an individual assignment and you should not receive any help from anyone. - You are free to use your book and notes. - Prepare your solution to both questions below in Excel (use formulae rather than calculators) and upload in your solution file on blackboard. Q1. Picture Pretty manufactures picture frames. Sales for August are expected to be 10,000 units of various sizes. Historically, the average frame requires four feet of framing, one square foot of glass, and two square feet of backing. Beginning inventory includes 1,500 feet of framing, 500 square feet of glass, and 500 square feet of backing. Current prices are $0.30 per foot of framing, $6.00 per square foot of glass, and $2.25 per square foot of backing. Ending inventory should be 150% of beginning inventory. Purchases are paid for in the month acquired. Required: a. Determine the quantity of framing, glass, and backing that is to be purchased during August. b. Determine the total costs of direct materials for August purchases