Prepare schedules for expected collections

Assignment Help Managerial Accounting
Reference no: EM132800742

Question - The University of Wisconsin and its subunits must prepare budgets.

One unique subunit of the University of Wisconsin is Babcock Ice Cream, a functioning producer of dairy products (and famous, at least on campus, for its delicious ice cream).

Assume that Babcock Ice Cream prepares monthly cash budgets. Relevant data from assumed operating budgets for 2012 are:

January February

Sales $460,000 $412,000

Direct materials purchases 185,000 210,000

Direct labor 70,000 85,000

Manufacturing overhead 50,000 65,000

Selling and administrative expenses 85,000 95,000

Babcock sells its ice cream in shops on campus, as well as to local stores. Collections are expected to be 75% in the month of sale, and 25% in the month following sale. Babcock pays 60% of direct materials purchases in cash in the month of purchase, and the balance due in the month following the purchase. All other items above are paid in the month incurred. (Depreciation has been excluded from manufacturing overhead and selling and administrative expenses.)

Other data:

(1) Sales: December 2011, $320,000.

(2) Purchases of direct materials: December 2011, $175,000.

(3) Other receipts: January-Donation received, $2,000 February-Sale of used equipment, $4,000.

(4) Other disbursements: February-Purchased equipment, $10,000.

(5) Repaid debt: January, $30,000.

The company's cash balance on January 1, 2012, is expected to be $50,000. The company wants to maintain a minimum cash balance of $45,000.

Required -

(a) Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases.

(b) Prepare a cash budget for January and February in columnar form.

Reference no: EM132800742

Questions Cloud

Explain what happened to the price of toilet paper : Explain what happened to the price of toilet paper at the start of the pandemic. What happened to the retail availability of this product?
What is the expected value of the next dividend : The required rate of return (r) on "ABC" Company is 15%, and it is currently selling its stocks at a price of $49.87. What is expected value of next dividend
Would that knowledge have affected your decision : Think about major purchases you have made in the past. Now that you know about opportunity cost, would that knowledge have affected your decision to make.
What factors have caused your demand for electronic devices : Right now you are using some type of electronic device (computer, phone, tablet, etc.) to answer this journal question. What factors have caused your demand.
Prepare schedules for expected collections : Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases
Create a project work breakdown structure : Provide a short explanation of the event, identify all stakeholders involved in the process, and create a project work breakdown structure
What background or educational experiences do you have : What background, personal, or educational experiences do you have with research in general or with creating arguments? After reviewing the materials.
What is the minimum amount bespoke joiners could quote : Fixed overheads of €10,000 will be assigned to the work. What is the minimum amount Bespoke Joiners could quote without lowering their profits
Determine the annual effective rate of interest of the plan : A 5 year investment plan pays j 1 = 5% in the years 5 and 4, j2 = 4% in the years 3 and 2, and j4 = 6% in year 1. Determine the annual effective rate

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