Question

In: Accounting

a. Sales budget b. Inventory, purchases, and cost of goods sold budget c. Operating expense budget...

a. Sales budget

b. Inventory, purchases, and cost of goods sold budget

c. Operating expense budget

d. Budgeted income statement

Data:

Operating expenses include sales commission – 10% of Sales

Insurance Expense – $400

Depreciation Expense – $1,200

Rent Expense – $1000

Utility Expense – $800

Michael’s Enterprise sells washing machines. Actual sales for the month ended June 30 were $30,000. Manuel expects sales to increase 7% in July and increase another 4% over July sales in August. Cash sales are expected to be 60% of total sales and credit sales about 40% of sales. Cost goods sold should be 60% of the total sales. Manuel does not want inventory to fall below $4,000 plus 10% of cost of goods sold for the next month. Sales of $35,000 are expected for September. Inventory for June 30 is $6,000.

Expert Solution

A.

Where the price per unit is expected to remain constant during the period for all units in sales, the sales budget format will be simple as shown below.

michael enterprices
Sales Budget


	Quarter
month	1. june	2. july	3. augusst	4. september	total
actual sales	$30,000
increase in sales		7 %	4 % over july
Total Sales	$30,000	$32,100	$ 33384	$35,000	$130484

However if a business sells more than one product having different prices or the price per unit is expected to change during the period, its sales budget will be detailed.

B.

Ending Inventory = (Beginning Inventory + Net Purchases) - (Cost of goods sold)

The calculation of inventory purchases is: $6000 - $ 78290 = $ 72290

(Ending inventory - Beginning inventory) + Cost of goods sold = Inventory purchases

$72290 - $6,000. + $ 78,290 = $ 144580

formula for cost of goods sold is:

Beginning inventory + inventory purchases – end inventory = cost of goods sold

here cogs = 60% of total sales

60% of $130,484 = $78,290

C. Operating expense budget = net sales - cogs - operatin expense

$ 49134 = $ 130484 - $ 78290 - $3060

d. BUDGED INCOME STATEMENT

SALES $130484

COST OF GOODS SOLD ($78,290)

NET INCOME = $ 52194

ekkarill92 answered 1 year ago

Using the following information calculate (a) Net Sales, (b) Beginning inventory, (C) Cost of goods sold,...

Using the following information calculate (a) Net Sales, (b) Beginning inventory, (C) Cost of goods sold, (d) gross margin, and (e) Net Income (INCOME AFTER TAXES) Sales salaries expense $7,000 Sales (gross) 90,000 Ending Inventory 16,000 Purchase returns and allowances 500 General and administrative expenses 8,000 Selling expenses 3.000 Sales discounts 1,200 Freight in 1,500 Freight out 2,500 Prepaid expenses 5,000 .Purchases(gross) 30,000 Cost of goods available for sale 63,000 Income taxes rate= 30%

Using the following information, calculate (a) Net sales, (b) Beginning inventory, (c) Cost of goods sold,...

Using the following information, calculate (a) Net sales, (b) Beginning inventory, (c) Cost of goods sold, (d) Gross margin, and (e) Net income (Income after taxes). Sales salaries expense $ 7,000 Sales (gross) 90,000 Ending Inventory 16,000 Purchase returns and allowances 500 General and administrative expenses 8,000 Selling expenses 3,000 Sales discounts 1,200 Freight in 1,500 Freight out 2,500...

Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods...

Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods Sold Inventory Event Unit Cost Total Cost Unit Cost Total Cost Total Cost QTY Bought Qty sold Qty Unit Cost Beginning Inventory 150 755 First Sale 120 First Purchase 400 785 Second Sale 200 Second Purchase 300 805 Sale 290 The firm uses the perpetual inventory system and there are 240 units of the item on hand at the end of the year A....

sales are1.53 million, cost of goods sold is 615000, depriciation, expense is 153,000, other operating expenses...

sales are1.53 million, cost of goods sold is 615000, depriciation, expense is 153,000, other operating expenses is $303,000 addition to retained earnings is 145,700,dividends per share is $1,tax rate is 30 percent,and number of shares of common stock outstanding is 93,000 Latonya's Flop Shops has no preferred stock outstanding. use above info to calculate the times interest earned ratio for Latonya's Flop Shops, inc (rd your ans to 2 decimal places

2013 2014 Sales $2100 Cost of Goods Sold $1200 Other operating expenses $200 Depreciation Expense $225...

2013 2014 Sales $2100 Cost of Goods Sold $1200 Other operating expenses $200 Depreciation Expense $225 Interest Expense $175 Current Assets $1000 $1300 Total Fixed Assets $3500 $4000 Accumulated Depreciation $1250 This can be determined from the information given Current Liabilities $900 $975 Long-term Debt $1500 $1350 Common Stock $400 This can be determined from the information given A company has the financial data above for years 2013 and 2014. The average tax rate is 35% and the dividend payout...

Sales are $3.70 million, cost of goods sold is $550,000, depreciation expense is $140,000, other operating expenses is $290,000. addition to retained

Sales are $3.70 million, cost of goods sold is $550,000, depreciation expense is $140,000, other operating expenses is $290,000. addition to retained earnings is $1,766,625, dividends per share are $1, tax rate is 21 percent, and number of shares of common stock outstanding is 80,000. Lafonya's Flop Shops has no preferred stock outstanding.Use the above information to calculate the times interest earned ratio for LaTonya's Flop Shops, Inc. (Round your answer to 2 decimal places.)Interest earned ________ times

8. If the cost of goods sold is $100,000, sales are $200,000, merchandise purchases are $37,000,...

8. If the cost of goods sold is $100,000, sales are $200,000, merchandise purchases are $37,000, and ending merchandise inventory is $10,000, then the beginning merchandise inventory must be: 9. A merchandiser plans to sell 14,600 units next month at a selling price of $110 per unit. It also gathered the following cost estimates for next month: Cost Cost Formula Cost of goods sold $60 per unit sold Advertising expense $150,000 per month Depreciation expense $70,000 per month Shipping expense...

income statement Sales 205,000 cost of goods sold -97,000 salaries expense -24,000 depreciation expense -16,000...

income statement Sales 205,000 cost of goods sold -97,000 salaries expense -24,000 depreciation expense -16,000 interest expense -2,400 loss on equipment disposal -2,500 net income 63,100 Statement of Retained Earnings Beginning Balance - Retained Earnings 6,000 Plus - Net Income 63,100 Less - Dividends (41,500) Ending Balance - Retained Earnings 27,600 Balance sheets 2018 2019 change Assets: Cash 13,000 64,600 51,600 Accounts Receivable 25,000 19,000 (6,000) Inventory 19,000 13,000 (6,000) prepaid expenses 0 0 0 Equipment 60,000 41,000 (19,000)...

Cost of goods sold $223,110 Salaries and wages expense $55,720 Delivery expense 6,320 Sales discounts 7,320...

Cost of goods sold $223,110 Salaries and wages expense $55,720 Delivery expense 6,320 Sales discounts 7,320 Insurance expense 12,760 Sales returns and allowances 11,820 Rent expense 18,640 Sales revenue 366,400 Prepare the necessary closing entries. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter 0 for the amounts.

2013 2014 sales 2100 Cost of Goods Sold 1200 Depreciation Expense 225 Interest Expense 175 Current...

2013 2014 sales 2100 Cost of Goods Sold 1200 Depreciation Expense 225 Interest Expense 175 Current Assets 1000 1300 Total Fixed Assets 3500 4000 Accumulated Depreciation 1250 This can be determined from the information given Current Liabilities 900 975 Long-term Debt 1500 1350 Common Stock 400 This can be determined from the information given Question 1 part one) Use the information above to construct a 2014 income statement and balance sheets for both years. The average tax rate is 35%...