To complete the unit sales forecast use your student

Reference no: EM13573920

The Bear Corporation will begin business operations on January 1, 2012. Below is the anticipated SALES BUDGET (in units):

Jan. __0,000

Feb. __0,000

Mar. __0,000

Apr. __0,000

May __0,000

1.To complete the unit sales forecast, use your student identification number to fill in the blanks. If your number contains a "0", use "3" instead.

Example: Student ID number is 146073578. The sales forecast would be:

January 10,000

February 40,000

March 60,000

April 30,000

May 70,000

ADDITIONAL INFORMATION

a.Ending finished goods inventory should be equal to 10% of next month's sales projection.

b.Each unit requires 3 pounds of material at a raw material cost of $5 per pound.

c:Labor cost is $10 per unit produced.

d.Ending raw material inventory should be equal to 20% of next month's material requirement.

e.Factory overhead is $18,000 per month of which $8,000 is for depreciation.

f.All costs are paid in the month incurred except for purchases which is paid in the following month.

REQUIRED: Using Excel, in good form:

Prepare a SALES BUDGET for the first quarter (January through March).
Prepare a PRODUCTION BUDGET for the first quarter (January through March).

Prepare a Raw Materials PURCHASES BUDGET for the first quarter (Jan. through Mar.)

Prepare a CASH DISBURSEMENTS budget for the first quarter (January through March).

Reference no: EM13573920

Questions Cloud

For each case determine a the exchange ratio in shares and : exchange ratio. the following information is providedcasemarket price per shareof acquiring companymarket price per

Costs classified as batch-level costs should depend on the : costs classified as batch-level costs should depend on the number of batches processed rather than on the number of

Georgia products inc completed and transferred 228000 : georgia products inc. completed and transferred 228000 particle board units of production from the pressing department.

What will earnings per share be subsequent to the merger : earnings per share. the following data concerning companies a and b are presentedcompany acompany bnet

To complete the unit sales forecast use your student : the bear corporation will begin business operations on january 1 2012. below is the anticipated sales budget in

How often do you look at a clock or watch during the day is : answer both questions with a minimum of 70 words per question1how often do you look at a clock or watch during the day?

Would theactivities at a manufacturer of canned soup be : would theactivities at a manufacturer of canned soup be best classified as unit-level batch-level product-level or

Due to merger negotiations company r offers 50 a share the : acquisition by exchanging stock. company r wishes to acquire company s. company rs stock sells for 100 per share.

Cole laboratories makes and sells a lawn fertilizer called : cole laboratories makes and sells a lawn fertilizer called fastgro. the company developed standard costs for one bag of

User Account

All Pages