Sales budget-including schedule of expected cash collection

Assignment Help Financial Accounting

Reference no: EM13825358

1. Sales forecast: January: 1,100 units; February: 1,500 units; March: 2,300 units; April: 2,500 units. The unit sales price is $38. All sales are on credit and collections are 30% in the month of sale and 70% the following month. Accounts receivable as of December 31, 2014 is $15,900 and this amount is expected to be collected in January 2015.

2. End of month inventory must equal 70% of next month’s sales. The inventory at the end of December 2014 was 1,200 units.

3. The following are the expected costs for direct materials, direct labor and manufacturing overhead:

DM DL Overhead

January $8/unit $15/unit $7,500 + $1.00 per unit produced

February $8/unit $15/unit $7,500 + $1.00 per unit produced

March $8/unit $15/unit $7,500 + $1.00 per unit produced

A. Direct materials are paid 20% in the month incurred and 80% in the following month.

Account payable for materials as of December 31, 2014 is $5,000; this amount will be paid in January 2015.

B. Direct labor is paid in the month incurred.

C. Overhead costs are paid in the month incurred. Fixed overhead includes depreciation of $2,500 per month.

4. Selling costs are sales commissions: $.50 per unit sold; shipping costs: $.20 per unit sold. Administrative costs per month are: salaries: $1,500; rent: $500; depreciation: $800. All costs are paid in month incurred.

5. The company plans to buy equipment costing $10,000 in January.

6. The cash balance as of December 31, 2014 is $10,550. The company borrows money only if the cash balance falls below $2,000 at the end of the month. The company has a revolving credit with US Bank to borrow in increments of $1,000 at the beginning of each month at interest of 12% annual rate. The company repays interest at the end of each month and principle (or portion) at the end of the month when they have the resources to do so. As of December 31, 2014 the company has no outstanding loans.

Required:

Based on the information given, prepare the following budgets for each month of the first quarter of 2015 and the quarter totals:

Sales Budget, including a schedule of expected cash collections;

Production Budget (in units);

Direct material , including schedule of expected cash disbursements;

Direct labor budget;

Manufacturing Overhead Budget;

Selling and Administrative Expenses Budget;

Cash Budget.

Reference no: EM13825358

Questions Cloud

Preparing and analyzing an annual report for a company : This problem belongs to Accounting and it is about collecting, preparing and analyzing an annual report for a company listed on the Australian Securities Exchange. For this purpose, the data from Billabong International Ltd has been taken

Central depository system and a central security depository : What is the difference between a central depository system and a central security depository

Is affirmative action allowable discrimination : Is "Affirmative Action" allowable discrimination? Putting aside the question of how effective affirmative action is, is it logical for government to sanction some discrimination and prohibit other discrimination?

What is the variable overhead spending variance : What is the variable overhead spending variance for the month?

Sales budget-including schedule of expected cash collection : Sales forecast: January: 1,100 units; February: 1,500 units; March: 2,300 units; April: 2,500 units. The unit sales price is $38. All sales are on credit and collections are 30% in the month of sale and 70% the following month. Based on the informati..

Compare radical behaviorism and cognitive science : Discuss skinnerss two mistakes according to staddon in additon to staddons criticism of skinners argument against the Autonomous man

What type of price discrimination they are engaged in : The problem belongs to Economics, Micro-economics and it is explain the problem about Coke being a monopolist and does it engage in price discrimination and the type of price discrimination that coke is engaged in the answer.

Sustainable business improvement in a global corporation : Sustainable Business Improvement in a Global Corporation: Shell Services

Total paid-in capital and total stockholders equity : Based on the preceding information, calculate each of the following: Total paid-in capital. Total stockholders' equity.

User Account

All Pages