Direct labor is paid in the month incurred.

Assignment Help Accounting Basics
Reference no: EM13972709

Required:

Based on the following information, prepare the following budgets for each month and the quarter ending March 31, 2011: (Hint: First quarter consists of January, February and March.)

Sales Budget, including a schedule of expected cash collections
Production Budget (in units)
Manufacturing Overhead Budget
Selling and Administrative Expenses Budget
Cash Budget

(Note: Even though you are not required to prepare Direct Materials and Direct Labor budgets, direct materials and direct labor information is necessary to prepare the Cash Budget.)

Information:

1. Sales forecast: January: 2,000 units; February: 1,700 units; March: 1,600 units; April: 1,500 units. The unit sales price is $16. All sales are on credit and collections are 40% in the month of sale and 60% the following month. Accounts receivable as of December 31, 2010 is $17,200 and this amount is expected to be collected in January 2011.

2. End of month inventory must equal 70% of next month's sales. The inventory at the end of December 2010 was 1,400 units.

3. The following are the expected costs for direct materials, direct labor and manufacturing overhead:
DM DL Overhead
January $14,800 $6,300 $5,610 + $1.50 per unit produced
February 8,600 5,700 $5,610 + $1.50 per unit produced
March 8,400 5,300 $5,610 + $1.50 per unit produced

A. Direct materials are paid 25% in the month incurred and 75% in the following month.
Account payable for materials as of December 31, 2010 is $5,400; this amount will be paid in January 2011.

B. Direct labor is paid in the month incurred.

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

4. Selling costs are sales commissions: $.30 per unit sold; shipping costs: $.14 per unit sold. Administrative costs per month are: salaries: $1,200; rent: $400; 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, 2010 is $10,200. The company borrows money only if the cash balance falls below $2,000 at the end of the month.

Reference no: EM13972709

Questions Cloud

Compute the payback period net present value : Compute the payback period, net present value, and accrual accounting rate of return with initial investment, for each proposal. Use a required rate of return of 14%.  (10 points)
How should training effectiveness be measured : How should training effectiveness be measured in an organization? What methods would you recommend for your current organization? Explain your reasons. If your organization provided tuition assistance so you could take this class, how would you re..
Tax effects of alternate methods of transferring : Alex's basis in any of the securities gifted to him will be the lesser of his parents' basis or the fair market value of the security. Discuss the tax effects of alternate methods of transferring $20,000 to Alex, and devise an optimal plan for mak..
Payment of unreimbursed medical expenses : Company B-Annual salary of $46,000, a cafeteria plan under which employees can choose benefits of up to 10% of annual salary or take the cash equivalent. In addition, the company has a flexible benefits plan in which employees may par- ticipate by..
Direct labor is paid in the month incurred. : Direct materials are paid 25% in the month incurred and 75% in the following month. Account payable for materials as of December 31, 2010 is $5,400; this amount will be paid in January 2011.
What was the best strategy for making wildtype flies : What strategies do you plan to use to make wildtype flies? What percentage of the class do you anticipate will be wildtype at the end? Eyeless? Curly?
Complete the recruitment and selection strategies : Complete the Recruitment and Selection Strategies Recommendations task, as described in the Email from Traci, located on the Atwood and Allen Consulting page
Problem regarding the scholarship taxable : Upon completion of the first year, Reggie will return to Big University and work on the research required to obtain his degree. During the second year, he will receive his scholarship from Big University. Is Reggie's scholarship taxable?
How you would adapt for general audience a piece of writing : Explain how you would adapt for a general audience a piece of technical or specialized writing (from an academic subject, professional field, or special interest publication).

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Fair value measurement for financial instruments

What are some steps taken by both the FASB and IASB to move to fair value measurement for financial instruments? In what ways have some of the approaches differed?

  Shaggy limited purchased a new van on january 1 2014 the

shaggy limited purchased a new van on january 1 2014. the van cost 20000. it has an estimated life of five years and

  During february winter companys employees earned wages of

during february winter companys employees earned wages of 50000. social security fica withheld was 2500 federal income

  Calculate price and efficiency variances for all of the

spam inc. had the following standard costs and plans for fiscal current year for the production of custom meat products

  Purchases of direct materials-beginning direct materials

For each of the following cases, find the missing data. Each case is independent of the others.

  The suta rate in yengling company state

Yengling Company's payroll for the year is $593,150. Of this amount, $211,630 is for wages paid in excess of $7,000 to each individual employee.

  Decision on accepting additional business

Decision on Accepting Additional Business

  De anza manufacturing has just hired a new controller diana

de anza manufacturing has just hired a new controller diana deanza. during her first week on the job diana was asked to

  Assume that the assembly department of advanced

advanced technologies produces notebook computers in three departments assembly testing and packing. prior to the start

  The curl up amp dye hair salon has died it must liquidate

the curl up amp dye hair salon has died. it must liquidate its assets. it has a building it must sell that originally

  The process of stating the basic dilemma and then

the process of stating the basic dilemma and then developing other questions by progressively breaking down the

  Which firm is facing more risk in terms of its current sale

Which firm has higher operating gearing. What is the expected net income of both firms. Would expected net income be for both firms if sales were a) 140,000 units and b) 180,000 units. Which firm is facing more risk in terms of its current sales pred..

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