Prepare a sales budget for the first quarter of the year

Assignment Help Managerial Accounting
Reference no: EM132960111

MPG Company specializes in unique baskets. The company has budgeted the following sales for the first four months of the year:

Month           Expected sales in units
January             4,000
February            6,000
March              20,000
April                2,000

The selling price of the baskets is $30 per unit. Based on history, the company expects that 10% of sales are cash received in the month of sale. Of the credit sales, half is collected one month after sale and the remainder is collected two months after sale. Accounts receivable as at January 1st was $100,000; all of which is expected to be collected in January.

The company wants ending inventory to be equal to 20% of the following month's budgeted sales in units. On January 1st, 1,000 units were on hand.

Required:

Problem a. Prepare a sales budget for the first quarter of the year.

Problem b. Prepare a schedule of expected cash collections for the first quarter of the year.

Problem c. Prepare a production budget for the first quarter of the year.

Reference no: EM132960111

Questions Cloud

What steps could senior management take to reduce the type : Addix Company manufactures accessories for road, What steps could senior management take to reduce the type of behaviour exhibited by Roth? Explain.
What is the impact of accrued liabilities on the fnancial : What is the impact of accrued liabilities on the fnancial statements? Should the accrued liabilities for wages and interest payable be removed from the balance
What amount of loss on these securities should be included : What amount of loss on these securities should be included in the statement of comprehensive income for the year ended December 31, 2015
What ethical concerns did the accountant have : What ethical concerns did the accountant have? If the total amount of repairs and mainte-nance was so large, couldn't a case be made
Prepare a sales budget for the first quarter of the year : Prepare a sales budget for the first quarter of the year. Prepare a schedule of expected cash collections for the first quarter of the year.
What is average collection period for accounts receivable : $42000 at the beginning of the year and end of year, respectively. What is the average collection period for accounts receivable in days?
Describe the reporting of pension plans for a company : Question - Describe the reporting of pension plans for a company with multiple plans, some of which are underfunded and some of which are overfunded
Find the payback period for the equipment : The equipment has an estimated life of 8 years, no estimated salvage life, and a required rate of return is 6%. Find the payback period for the equipment
Compute the net present value of the project : The salvage value of the assets used in the project would be $38,950. The company uses a discount rate of 10%. Compute the net present value of the project

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