Prepare the selling expense budget

Assignment Help Accounting Basics
Reference no: EM132013726

Mini Case - Budgets

Wild Wood Company's management asks you to prepare its master budget using the following information. The budget is to cover the months of April, May, & June 2014

Molly Dolls Balance Sheet March 31, 2014

Assets


Liabilities


Cash

$50,000

Accounts payable

$156,000

Accounts receivable

175,000

Short-term note payable

12,000

Inventory

126,000

Total current liabilities

168,000

Total current assets

351,000

Long-term notes payable

200,000

Equipment

480,000

Total liabilities

368,000

Accumulated depreciation

(90,000)

Common stock

235,000

Total assets

$741,000

Retained earnings

138,000



Total liabilities & equity

$741,000

Additional Information -

a. Sales for March total 10,000 units. Each month's sales are expected to exceed the prior month's results by 5%. The product's selling price is $25 per unit.

b. Company policy calls for a given month's ending inventory to equal 80% of the next month's expected unit sales. The March 31 inventory is 8,400 units, which complies with the policy. The purchase price is $15 per unit.

c. Sales representatives' commissions are 12.5% of sales and are paid in the month of the sales. The sales manager's monthly salary will be $3,500 in April and $4,000 per month thereafter.

d. Monthly general and administrative expenses include $8,000 administrative salaries, $5,000 depreciation, and 0.9% monthly interest on the long-term note payable.

e. The company expects 30% of sales to be for cash and the remaining 70% on credit. Receivables are collected in full in the month following the sale (none is collected in the month of the sale).

f. All merchandise purchases are on credit, and no payables arise from any other transactions. One month's purchases are fully paid in the next month.

g. The minimum ending cash balance for all months is $50,000. If necessary, the company borrows enough cash using a short-term note to reach the minimum. Short-term notes require an interest payment of 1% at each month-end (before any repayment). If the ending cash balance exceeds the minimum, the excess will be applied to repaying the short-term notes payable balance.

h. Dividends of $100,000 are to be declared and paid in May.

i. No cash payments for income taxes are to be made during the second calendar quarter. Income taxes will be assessed at 35% in the quarter.

j. Equipment purchases of $55,000 are scheduled for June.

Required - Prepare the following budgets and other financial information as required:

1. Sales budget, including budgeted sales for July.

2. Purchases budget, the budgeted cost of goods sold for each month and quarter, and the cost of the June 30 budgeted inventory.

3. Selling expense budget.

4. General and administrative expense budget.

5. Expected cash receipts from customers and the expected June 30 balance of accounts receivable.

6. Expected cash payments for purchases and the expected June 30 balance of accounts payable.

7. Cash budget.

8. Budgeted income statement.

9. Budgeted statement of retained earnings.

10. Budgeted balance sheet.

Reference no: EM132013726

Previous Q& A

  Establishing causal claims in political science

Why are poorly measured variables a barrier to establishing causal claims in political science?

  How does pluralism and democratic theory benefit

Is it wise for the electorate to be making law directly? How so? How does pluralism and democratic theory benefit?

  Benefit from direct law making

How does pluralism and democratic theory benefit from direct law making?

  Difference between intensity and magnitude measurements

Explain the difference between intensity and magnitude measurements when evaluating an earthquake. What scales are used to measure each?

  What is a california public policy

What is a California public policy that you consider to be exceptional and why?

  Is wealth inequality a problem

Is wealth inequality a problem? If so, what do you think might be some good ways to address it?

  Do the people engaged in the conflict understand

Do the people engaged in the conflict understand what they are fighting for? Does all the people ostensibly belonging to the same side want the same thing?

  Single member district and proportional representation

Compare and contrast single member district and proportional representation (PR). How effective is each electoral system in representing it's people's interests

  Study democratic decay and keep canada

If the researcher keeps states as the unit of analysis, how could she proceed to study democratic decay and keep Canada in her study?

  What is the host of the web site

The World Wide Web (also known as just 'the web' or 'the internet') is a network of several million web 'pages' written in Hypertext Markup Language (HTML).

Reviews

Write a Review

 

Similar Q& A

  Discuss the theory of international diversification

International Risk. Many portfolio managers, when asked why they do not internationally diversify their portfolios, answer that "the risks are not worth.

  A 30000 note payable is retired at its 30000 carrying book

a. a 30000 note payable is retired at its 30000 carrying book value in exchange for cashb. the only changes affecting

  Allocate net income to partners based on partnership terms

Allocate the net income to partners based on the above partnership terms and prepare allocation journal entries

  Problem regarding the business-procurement venture

Exactly two of the contracts? Exactly three of the contracts? All four contracts? Overall, what is OfficeQuip's expected profit in this business-procurement venture?

  Differences between depreciation expense and accumulated

Explain the differences between depreciation expense and accumulated depreciation.

  Why is control over unauthorized access so important

Why is control over unauthorized access so important in a database environment?

  The same organization s managerial performance evaluation

1.which of the following items represents a business risk in capital structure decisions?a.management

  Calculate the changes in the financial statements

BUS103 Accounting for Managers Team Assignment. Required: In relation to the financial statements of Stratum Limited given below answer the following questions. Calculate the changes in the financial statements from 2017 to 2016 in both dollar amount..

  What is the amount of cash that buyer pays the seller

A sales invoice included the following information: merchandise price, $68,000; what is the amount of cash that buyer pays the seller

  What is the unit product cost for the month

What is the unit product cost for the month under variable costing? Prepare a contribution format income statement for the month using variable costing

  Interest and the discount amortization

(a) The issuance of the bonds. (b) The payment of interest and the discount amortization on December 31, 2014. (c) The redemption of the bonds at maturity, assuming interest for the last interest period has been paid and recorded. No. Date Account Ti..

  Performance measurement practices

Compare three performance measurement practices. Determine appropriate financial compensation and rewards using the scenario from your Week 3 assignment and explain your rationale of selecting the financial compensation and rewards.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd