Solution-Make a schedule of forecasted sales on a rolling

Make a schedule of forecasted sales on a rolling basis

Assignment Help Managerial Accounting

Reference no: EM132755670

You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year.

In December of the prior year, sales were forecasted as follows: January, 93 units; February, 88 units; March, 95 units; April, 100 units; May, 107 units; June, 115 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 83 units; March, 95 units; April, 95 units; May, 97 units; June, 110 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 90 units; April, 95 units; May, 92 units; June, 110 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 95 units; May, 87 units; June, 100 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 77 units; June, 95 units. In May of the current year, sales for June were reforecasted as 95 units.

Actual sales for the six-month period, January through June, were as follows: January, 82 units; February, 83 units; March, 94 units; April, 99 units; May, 101 units; June, 110 units.

Required:

Problem 1. schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive.

Reference no: EM132755670

Questions Cloud

Manufacturer of disposable diapers : Imagine that you are the marketing manager for a U.S. manufacturer of disposable diapers

What advice should give the borrower : What advice should you give this borrower? Assume a competitive loan market in which each bank is constrained to earn zero expected profit.

What is the amount of fixed costs : The variable costs as a percentage of revenue are 70%. The income tax rate is 40%. What is the amount of fixed costs

What global marketing strategies : What global marketing strategies have these companies implemented to stay ahead of their competitors?

Make a schedule of forecasted sales on a rolling basis : Actual sales for the six-month period, January. Make a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive.

How much would each preferred shareholder receive : On 1/1/20, RAD Corp issued $100 Par Value Preferred Stock with provisions for $5 dividends. How much would each preferred shareholder receive

What is the relationship between culture and innovation : Discuss the following as it pertains to creating a culture of innovation: What is the relationship between culture and innovation?

Determine the contribution margin ratio : United Merchants Company sells 24,000 units at $27 per unit. Variable costs are $15.93 per unit, and fixed costs are $135,500. Determine the contribution margin

Develop a balanced scorecard that can be used to monitor : Develop a Balanced Scorecard that can be used to monitor and manage the performance of the customer call centre. To assist in this process

User Account

All Pages

Make a schedule of forecasted sales on a rolling basis

Reference no: EM132755670

Reference no: EM132755670

Questions Cloud

Reviews

Write a Review

Managerial Accounting Questions & Answers

Manage budgets and financial plans

Prepare a retained earnings statement

Prepare a master budget for the three-month period

Construct the companys direct labor budget

Evaluate the predetermined overhead rate

Determine the company''s bid

Compute the pool rates for the different activities

Prepare Company financial statements

Prepare an analysis of terracycles

Discuss the ethical issues

Political resources in emerging markets

Management accounting - ehsan electronics company

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT