Prepare a forecasted balance sheet for the months

Assignment Help Financial Accounting
Reference no: EM13488663

Mile High Inc. was formed in March 2011 to provide prepackaged snack boxes for a new low cost regional airline beginning April 1. The Company has just leased warehouse space central to the two airports to store materials.

To move packaged materials from the warehouses to the airports, where final assembly will take place, Mile High must choose whether to lease a delivery truck or pay a full-time driver at a fixed cost of $5,000 per month or pay a delivery service a rate equivalent to $0.40 per box. This cost will be included in either fixed manufacturing overhead or variable manufacturing overhead, depending on which option is chosen. The company is hoping for rapid growth, as sales forecasts for the new airline are promising. However, it is essential that Mile High managers carefully control costs in order to be compliant with their sales product and remain profitable.

Ron Spencer, the company's president, is trying to determine whether to use absorption or variable costing to evaluate performance of company managers. For absorption costing, he intends to use the practical capacity level of the facility, which is 20,000 boxes per month. Production volume variances will be written off to cost of goods sold.

Costs for the three months are expected to remain unchanged. The costs and revenues for April, May and June are expected to be as follows:

Sales revenue


$6.00 per box

Direct material cost


$1.20 per box

Direct manufacturing labor cost


$0.35 per box

Variable manufacturing overhead cost


$0.15 per box

Variable delivery cost (if this option is chosen)


$0.40 per box

Fixed delivery cost (if this option is chosen)


$5,000 per month

Fixed manufacturing overhead costs


$15,000 per month

Fixed administrative costs


$28,000 per month

Projected production and sales for each month follow. High production in May is the result of an anticipated surge in June employee vacations.


Sales (in units)

Production

March

0

12,200

April

12,000

18,000

May

12,500

9,000

June

13,000

12,000

Total

37,500

39,200

Since Mile High is a start-up business, they were able to negotiate extended payment terms with direct materials vendor. Their standard payment terms of 30 days were extended to 60 days for the first three months. Payments for variable manufacturing, fixed manufacturing and administrative costs are payable in 30 days. Labor costs are payable in the month incurred. Regional airports are billed upon delivery and have 30 day payment terms with the opportunity to qualify for a 1% discount by December 31 based on timely payment experience. Mile High anticipates that 50% of their customers will pay within the first 30 days and 20% will pay within 60 days. The remaining 30% will take 90 days to remit payment. This experience data is based on benchmarking of industry trends. Ideally the 1% discount will serve as an incentive for customers to pay faster than the benchmarking data suggests.

Ron Spencer is the sole proprietor of Mile High and he contributed $82,000 of packaging equipment to the business in exchange for his ownership. He was able to secure a line of credit $75,000 from a business associate which will be drawn down March 2013 to fund the initial operating expenses of Mile High. He will be successful in attracting additional investors if Mile High reaches its sales targets and can effectively manage cash flows during this critical startup period.

In an effort to further manage costs, Ron Spencer has hired his nephew Arnold, an undergraduate accounting student, to assist with preparing the projected income statement, balance sheet and cash flows.

1. Prepare a budgeted income statement, under absorption costing for Mile-High for the months of April, May and June assuming that Mile High opts to use the variable delivery service. Include supporting schedules to support the revenues and manufacturing costs.

2. Prepare a cash budget (budgeted statement of cash flows) for the months of April, May and June. Include supporting schedules for customer collections and vendor payments.

3. Prepare a forecasted balance sheet for the months of April, May and June using budgeted income statements and the budgeted statement of cash flows.

4. Will Ron Spencer achieve his goal of attracting additional investors based on the budgeted operating results and financial position for the months of April, May and June for Mile High? Why or Why Not?

5. Are there any operational trends that you would bring to the attention of Ron Spencer? What operational changes if any should he consider to address these trends?

Reference no: EM13488663

Questions Cloud

Find the intensity level in decibels at that distance : An outside loudspeaker (considered a small source) emits sound waves with a power output of 80 W. Find the intensity level in decibels at that distance
Compute arrows direct labor variances : Total overhead incurred amounted to $508,400. Budgeted fixed overhead totals $1.8 million and is spread evenly throughout the year.
Explain the benefit of using flexible budgets : The company normally manufactures between 20,000 and 25,000 units each quarter. Should output exceed 25,000 units, maintenance and other fixed costs are expected to increase by $6,000 and $4,500, respectively.
Compute the materials price variance : Banner Company manufactures flags of various countries. Each flag has a standard of eight square feet of fabric and three hours of direct labor time. Information about recent production activity follows.
Prepare a forecasted balance sheet for the months : Prepare a budgeted income statement, under absorption costing for Mile-High for the months of April, May and June assuming that Mile High opts to use the variable delivery service.
Find direction of the final velocity of the composite object : An object with a mass of 3.00 kg, moving with an initial velocity of 5.00i m/s, find the direction of the final velocity of the composite object
Define comprehensive budgeting : Watson uses four units of direct material in each finished unit. The direct material price has been stable and is expected to remain so over the next six months. Management wants to maintain the ending direct materials inventory at 60% of the f..
Find the average power generated by the horn : A train sounds its horn as it approaches an intersection. The horn can just be heard at a level of 56 dB by an observer 10 km away. What is the average power generated by the horn
Find the unknowns in big chucks abbreviated cash budget : Determine the outstanding loan balance as of September 30, after any repayments have been made.

Reviews

Write a Review

Financial Accounting Questions & Answers

  What kind of an accounting change is this

What kind of an accounting change is this? It indicates that TimeWarner rapidly changed its position with regard to these lawsuits. Is this a change in accounting principle?

  Determine boyd taxable income and his total tax liability

During 2010, he earns gross revenues of $49,000 and incurs $6,000 of business expenses. His itemized deductions for the year are $80,000. Determine Boyd's taxable income and his total tax liability.

  How many trades must be made to break even

Use the Contribution margin ratio CVP formula to compute National breakeven in dollars. If the average trade leads to $1000 in revenue for National how many trades must be made to break even?

  Prepare the companys budgeted balance sheetnbspthe

prepare the companys budgeted balance sheet.nbspthe management of mecca copy a photocopying center located on

  Calculation of goods available for sale inventory and

calculation of goods available for sale inventory and cogs.oju company uses the periodic inventory system and applied

  What is total amount of revenue from long-term contracts

What is total amount of Revenue from Long-Term Contracts recognized for 2010 and what is the balance in the Accounts Receivable account assuming Cannon Cafe has not yet made its last quarterly payment?

  Evaluation of mortgage option valuekim and dan bergholt are

evaluation of mortgage option value.kim and dan bergholt are both government workers. they are considering purchasing a

  Application of lifo fifo and weighted average method of

application of lifo fifo and weighted average method of inventory system.lakia corporation reported the following

  Multiple choice questions on valuation of bonds and

multiple choice questions on valuation of bonds and stocks.1.nbspfor bonds payable the cash interest paid in each

  Prepare a cash budget for knightsbridge corporation

Create a cash budget for Knightsbridge Corporation for the month of June 2012. The template of the cash budget is given below.

  Purpose an income statement for the first year

Preparation of Income statement from the given transactions - Purpose an income statement for the first year

  What are the disadvantages of avco method the purchasing

what are the disadvantages of avco method? the purchasing department had hoped to have a contract finalized to purchase

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