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.

Q2. Michelle Enterprises reports the year-end information from 20X5 as follows:

Sales (100,000 units) $250,000

Less: Cost of goods sold 150,000

Gross profit 100,000

Operating expenses (includes $10,000 of Depreciation) 60,000

Net income $ 40,000

Michelle is developing the 20X6 budget. In 20X6 the company would like to increase selling prices by 10%, and as a result expects a decrease in sales volume of 5%. Cost of goods sold as a percentage of sales is expected to increase to 62%. Other than depreciation, all operating costs are variable.

Required:

Prepare a budgeted income statement for 20X6.