Prepare the cash budget and comment on the company financial

Assignment Help Managerial Accounting
Reference no: EM132813940

ARMICO Corporation has edited the following financial data at December, 31, 2010:

Inventories at 31st of dec. :

Direct Materials : 4 400 units

Value: 8 800 $

Finished goods : 1 400 units

Value: 20 160$

Cash at 31st of dec: 10 200 $

Acounts receivable at 31st of dec: 17 200$

Accounts Payable in january: 5 400$

a. The sales forecast is 2000, 1700, i600 and 1500 units for january, Febuary march and April, respectively, the unit price is $16. all sales are on credits and collections are 40% in the month of sale and 60% the following month. accounts receivable is for credit sales only

b. at the end of each month tool time wants a finished goods inventory equal to 70% of the next month sales and direct materials inventory of 20% of that months production

c. A units of finished product requires 3 pounds of direct material at $2 a pound and 30 minute of direct labour at $7 an hour. Direct material purchases are paid 25% in the month of purchase and 75% in the following month. Account payable is for credit purchases only. all other costs are paid in the month incurred

d. Manufacturing overhead consist of the following: indirect material $0.50 per unit. indirect labour $0.60 per unit. other variable costs $0.40 per unit, salaries $3000 per month, depreciation $1,500 per month and other fixed costs $1,110 per month

e. selling costs are sales commission($0.30 per unit sold )and shipping($0.14 per unit sold) . Administrative costs each month are salaries $800, rent $500 and depreciation $400

f. Total time plans to buy equipment costing $10000 in January

Problem 1: Prepare the operating budgets (sales, production, DM budget, Labor budget, overheads budget (with the calculation of the estimated overhead rate), selling and administrative expenses budget) for the first quarter of 2011 for each month and the quarter in total.

Problem 2: Prepare the income statement

Problem 3: Prepare the cash budget and comment on the company financial Situation

Reference no: EM132813940

Questions Cloud

What is the break-even points in units : What is the break-even points in units? Granite Corp. manufactures curling rocks and sells them for $43/each. Variable costs are $23/each
What is the market price of a share of stock : A project has sales of $611,208, cash costs of $338,911, and depreciation expense of $74,209. The tax rate is 34 percent and the discount rate is 14 percent.
How many dollars the cash management system has freed up : $4.60 million per day in collections and $3.60 million per day in disbursements. Calculate how many dollars the cash management system has freed up?
Create the nursing care plans using given details : Critical thinking and Evidence-based practice are both very important parts of being a nurse. Critical thinking as explained by The Foundation for Critical.
Prepare the cash budget and comment on the company financial : Prepare the cash budget and comment on the company financial Situation. The sales forecast is 2000, 1700, i600 and 1500 units for january, Febuary and march
Calculate Atlas turnover ratio for last year : Atlas Company provided the following information for last year: Operating income $92,000. Calculate Atlas's turnover ratio for last year
Why the fda was responsible for investigating the case : Explain why the FDA, not OSHA, was responsible for investigating this case. Explain how the Culture of Safety model could have been applied to reduce risk.
How much are the proceeds that topeka outfitters : How much are the proceeds that Topeka Outfitters? will receive on the issue date of the bonds? Prepare an amortization table for the bond issue
Explain what the time value of money is : Please address one of the following topics. Please keep your responses brief and productive.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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