PR1 Prepare a Budgeted Statement of Financial Performance (also called a Budgeted Income Statement) for Fraser & Company for July, August and September including the total for quarter ended 30 September. List the expense accounts under the areas of Marketing, Administration and Financial Expenses Sales budget: July $50 000 August $60 000 September $90 000 All sales are on credit and 20% of customers are expected to receive a 5% prompt payment discount 2% of all customers'accounts are expected to be uncollectible. Sales price is a mark-up of 100% on the cost of goods sold. Interest expense is expected to be $1,000 per month. Rentalincome is $2 000 per month. The owner intends to withdraw $5 000 per month for personal expenses. Marketing expenses have a fixed cost element of $5000 per month, plus a variable cost element which is 10% of sales. General and administrative expenses are $9000 per month . July Aug Sep Total Sales 50,000 60,000 90,000 200,000 50 Less: COGS 100/200 = 25,000 30,000 45,000 100,000 25,000 30,000 60,000 170,000 Gross Profit Less Bad Debts 2% 1,000 1,200 1,800 4,000 490 588 882 1,960 Discount Allowed Marketing Expenses Fixed 5,000 5,000 5,000 5,000 10 96 5,000 Variable 6,000 9,000 20,000 General&Adm. exp. 9,000 9,000 9,000 9,000 Interest expense 1,000 1,000 1,000 1,000 3,510 7,212 33,318 129,040 Income from operation Other Income Rent 2,000 2,000 2,000 2,000 X Net Profit 5,510 9,212 35,318 131,040 ** It is assumed that the 20% customer for discount allowance is the customer after bad debts It is not stated in the question but actually discount is allowed to customer who pays the amount Jul Aug 5500 9200 It can be taken as 20% of the sales value by other assumption Sep Total 35000 20300