Calculate the cash flow budget for empire enterprises

Assignment Help Managerial Accounting
Reference no: EM131115715

Problem 1 - Standard and Actual numbers have been provided for Direct Material, Direct Labor and Fixed MO, Variable MO.  Calculate all variances indicated and also identify each variance as either Favorable (F) or Unfavorable (U).  Standard numbers provided are for 1 unit of final product manufactured.

Round all TOTAL VARIANCES to the nearest dollar for analysis purposes.

Problem 2 - You have been given the sales for a series of months.  The collection pattern is at the bottom and indicates 40% collected in the month of the sales, 30% in the next month and the remaining 25% in the third month.  Uncollectible amounts are 5% of total monthly sales and ignored.  Calculate the amount of cash collections in the Third Quarter.

The columns represent the amounts that will be collected in that particular month.

The rows represent the distribution of cash collections over the collection pattern months, related to the sales in the month listed on each row.

Problem 3 - Calculate the cash flow budget for Empire Enterprises for the 2016 year, on a quarterly basis.  All revenue and expense items have been provided.  Complete all necessary calculations for the cash budget.

The minimum cash ending balance for each quarter is $50,000.  You have a total line of credit available in the amount of $300,000.  Interest per quarter is 3% calculated on a simple interest basis and paid only when principal on the loan is repaid, i.e. interest is not accrued. 

All borrowings are considered to occur on the first day of a quarter.  All repayments are considered to occur on the last day of a quarter.  All borrowings/repayments are in increments of $1,000, except for a total payoff where the exact amount is paid.  Beginning cash balance on January 1, 2016 will be $70,000.

Problem 4 - Jefferson Digital Diagnostics Products started their annual budget process.  You are developing the Production Budget for the 4th quarter of 2016.  The monthly sales budgets are given in units.  The ending inventory of units has been provided for September.  Management desires an ending inventory of 20% of the next month's sales units---raw material supplies from vendors are tight due to insufficient production capacity in suppliers' network. 

Calculate the production budget for the 4th Quarter, by month and total.

Problem 5 - Bubbly Brew is specialty beer producer. Beer is produced by the keg.  Each keg requires 0.25 DLH to produce. Kegs produced are given.

The base DL pay is $10/hour for hours worked.   A 10% pay increase will go into effect April 1.  There is no minimum payment for labor cost.

Employees receive a 50% overtime premium on base hourly wage rate for all overtime hours worked.  Contract negotiations indicate that all DLH in excess of 5,000/month are subject to overtime pay.  You are calculating the base pay and overtime premium in two separate lines and adding them together.

Calculate the DL budget.

Problem 6 - Mays Landing Manufacturing, Inc. produces two products for the high tech industry in its NJ facilities: 

The company expects, during the current year, to produce and sell:

Product

Units

Product - PD-88

423

Product - ND-76

288

The company uses activity-based costing to compute unit product costs for external reports. Using the activity-based costing approach, determine the overhead cost per unit for each product.

Data relating to the company's four activity cost pools are shown on the spreadsheet:

Activity Cost Pool

Estimated
Overhead Costs

Expected Activity

Product - PD-88

Expected Activity

Product - ND-76

Purchase orders

$24,000

46

34

Direct material movement

$145,215

350

280

Machinery Setups

$16,640

22

10

General factory

$361,800

2,080

1,940

Calculate the Activity Rate for all activity pools.

Calculate the applied ABC costs for both products, given the expected sales above and the actual activity for each product. Determine both the total ABC overhead costs and the overhead cost per unit.

Attachment:- Assignment.rar

Reference no: EM131115715

Questions Cloud

Write farriss memo to home office to report on her purchases : Write Farris's memo to the home office to report on her purchases. Include the store's balance sheet as the final part of your memo. Prepare a T-account to compute the balance for Cash.
Unique normal distribution : When one thinks of the normal distribution, the first thing that comes to mind is the bell curve and grades. While this is one example of a normal curve that is widely recognized, it is not the only one. Try to come up with a unique normal distrib..
How many rotations will the smaller gear make : What is the angle measure, in degrees and rounded to the nearest tenth, through which the larger gear has rotated when the smaller gear has made one complete rotation?
Minimize the sum of annual ordering and carrying costs : A large law firm uses an average of 44 boxes of copier paper a day. The firm operates 264 days a year. Storage and handling costs for the paper are $27 a year per box, and it costs approximately $60 to order and receive a shipment of paper. What orde..
Calculate the cash flow budget for empire enterprises : Calculate the cash flow budget for Empire Enterprises for the 2016 year, on a quarterly basis.  All revenue and expense items have been provided.  Complete all necessary calculations for the cash budget
Ethics-corporate governance-corporate social responsibility : "Ethics, Corporate Governance, and Corporate Social Responsibility (CSR) " Please respond to the following:
Compute the costs per equivalent unit for april for mixing : Compute the costs per equivalent unit for April for mixing, materials, and conversion. Determine the total cost of ending work in process inventory and the total cost of units transferred to the Packaging Department in April.
The company uses the periodic inventory system : On August 1, the board of directors declared a $300,000 cash dividend that was payable on September 10 to stockholders of record on August 31.
Evolving global leadership development plan : Evaluation of an emerging leadership theory and its appropriateness for the organization.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Complete a management accounting

How much would you charge to complete a management accounting and business online test which is 16 questions and has a 1.5 hr time limit?

  Evaluate and comment on the merits of their proposal given

Review the chapter's opening feature highlighting Derick Pearson and Felecia Hatcher and their company, Feverish Ice Cream.

  What is the direct materials flexible budget variance

What is the direct materials flexible budget variance for steel used to manufacture the trains?

  How will the switch to fifo affect far eastern

How will the switch to FIFO affect Far Eastern's balance sheet?

  Determine the net present value of the investment

Determine the net present value of the investment in the paint and body shop. Should Sonnetson invest in the paint and body shop?

  Identifying the inventory accounts

Shown here are annual financial data at December 31, 2013, taken from two different companies.

  Operating activities section of the statement of cash flows

Prepare the operating activities section of the statement of cash flows for 2014 for ABC Remodel using the indirect method.

  Create a memo on the state of the companys industry

Create a memo on the ‘state of the company's industry' and associated risk factors.

  Federal income tax liability

Mike and Nancy's AGI was $175,000 and their actual federal income tax liability was $29,000 -  Federal income tax withheld from salary

  Income statement and selected balance sheet data

1.Lansing Company's 2013 income statement and selected balance sheet data at December 31, 2012 and 2013 follow.

  In preparation for the audit of an end user developed

In preparation for the audit of an end-user-developed application, what are the important questions the auditor can ask about the data that can help in assessing application risk?

  Compute the total amount of overhead cost

The following is taken from Mortan Co.'s internal records of its factory with two operating departments.

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