Prepare a budgeted balance sheet as of the end

Assignment Help Managerial Accounting
Reference no: EM13952167

The results of operations for the Preston Manufacturing Company for the fourth quarter of 2011 were as follows:

1274_259-B-M-A-B-P-C (1166).png

Preston Manufacturing uses the variable costing method. Thus, only variable production costs are included in inventory and cost of goods sold. Fixed production costs are charged to expense in the period incurred.

The companys balance sheet as of the end of the fourth quarter of 2011 was as follows: 

Assets:
Cash ..................$ 165,000
Accounts receivable ............$ 220,000
Inventory ................$ 385,000
Total current assets ............$ 770,000
Property, plant, and equipment ........$ 440,000
Less accumulated depreciation ........ $ 110,000
Total assets .............. $1,100,000
Liabilities and owners equity:
Accounts payable .............$ 66,000
Common stock ..............$ 550,000
Retained earnings ............$ 484,000
Total liabilities and owners equity ..... $1,100,000

Additional information:

1. Sales and variable costs of sales are expected to increase by 10 percent in the next quarter.
2. All sales are on credit with 60 percent collected in the quarter ofsale and 40 percent collected in the following quarter.
3. Variable cost of sales consists of 40 percent materials, 40 percent direct labor, and 20 percent variable overhead. Materials are purchased on credit. Fifty percent are paid for in the quarter of purchase, and the remaining amount is paid for in the quarter after purchase. The inventory balance is not expected to change. Also, direct labor and variable overhead costs are paid in the quarter the expenses are incurred.
4. Fixed production costs other than $9,000 of depreciation expense are expected to increase by 2 percent. Fixed production costs requiring payment are paid in the quarter they are incurred.
5. Fixed selling and administrative costs other than $8,000 of depreciation expense are expected to increase by 2 percent. Fixed selling and administrative costs requiring payment are paid in the quarter they are incurred.
6. The tax rate is expected to be 40 percent. All taxes are paid in the quarter they are incurred.
7. No purchases of property, plant, or equipment are expected in the first quarter of 2012.

Required:

a. Prepare a budgeted income statement for the first quarter of 2012.
b. Prepare a cash budget for the first quarter of 2012.
c. Prepare a budgeted balance sheet as of the end of the first quarter of 2012.  

Reference no: EM13952167

Questions Cloud

In an article from beckman states : In an article from Beckman (2001) states,"Improved student learning requires teachers, schools, and districts to give up unproductive traditions and beliefs, replacing them with validated practices and a full understanding of the intent of the law..
Compute the discounted payback period for a project : Compute the discounted payback period for a project with the following cash flows, if the company's discount rate is 12%.
Incremental after-tax cash flows from operations : Artie's Soccer Ball Company is considering a project with the following cash flows: Initial outlay = $750,000 Incremental after-tax cash flows from operations Years 1-4 = $250,000 per year Compute the NPV of this project if the company's discount rat..
A project has an initial outlay : A project has an initial outlay of $4,000. It has a single payoff at the end of Year 4 of $6,996.46. What is the IRR for the project (round to the nearest percent)?
Prepare a budgeted balance sheet as of the end : Prepare a budgeted balance sheet as of the end of the first quarter of 2012.
Project requires an initial investment : Project H requires an initial investment of $100,000 and the produces annual cash flows of $45,000 per year for each of the next 3 years. Project T also requires an initial investment of $100,000 and produces cash flows of $30,000 in year 1, $40,000 ..
Mlk speech make use of intertextuality : What is intertextuality? How does MLK's speech make use of intertextuality? Identify the texts that King either refers to or repeats language from. Be complete. Don't omit any examples. (You only need the handouts what I post it.
Draw out a generic reversible carnot cycle graph of pressure : Draw out a generic reversible Carnot cycle graph of pressure vs volume for an ideal gas. i. Label the cycle vertices A-D with temperature, pressure and entropy (e.g., TA, PA, SAfor the first point, and TB, PB, SB for the second point, etc.).
Considered capital budgeting decision : Which of the following would be considered a capital budgeting decision? A) Walmart purchases inventory for resale to customers. B) Apple sells bonds and uses the proceeds to repurchase stock. C) Goldman Sachs obtains short-term loans to finance day ..

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Question 1maxx inc has provided the following data from its

question 1maxx inc. has provided the following data from its activity-based costing systemactivity cost poolsnbsp

  Find the total and unit cost of finished goods

Find the total and unit cost of finished goods started and completed in the current period. Find the total cost of work in process inventory at June 30.

  Job descriptions and job functions

What would you include in a job description for a new cashier? How about a sales person? What is included on your job description? Are there functions you perform that are not in your job description?

  Calculate the break-even dollar sale volume for each project

Assuming that three units of product A are sold for every four units of product B, calculate the dollar sales volume necessary to break-even.    As part of its cost accounting routine, Wilcox Company assigns $36,000 in fixed costs to each product e..

  Suppose a job required parts costing

Suppose a job required parts costing $200 and technician time costing $100.What would be the total cost of the job?

  Prepare an income statement for fiscal

Prepare an income statement for fiscal 2011 Ignore income taxes.

  For the list of product manufacturers below

For the list of product manufacturers below, indicate whether a job-cost system (J) or a process cost system (P) would be most appropriate.

  Fixed and variable costs in the personnel department

Refer to exercise 9-24. Kurt, the manager of the Ohio unit, is unhappy with the results of the controller's study.

  Spam inc had the following standard costs and plans for

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

  Examining the cvp

Please give a 4-6 page with references about the information attached. This information will be employed as informative guidance to assist me completing the work prescribed. In particular analyzing and explaining financials.

  Small dreams management control systems

Identify the main problem and issues. Identify the main problems with Small Dreams' management control systems and operations.

  Analyze the financial performance of the firm

Using the calculated ratios, analyze the financial performance of the firm. You will do this by looking at the ratios and comparing them to ratios from previous periods and in some cases, against their competitors.

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