Question

The Bear Corporation will begin business operations on January 1, 2015. Below is the anticipated SALES...

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

   Jan.                 __0,000

Feb.                 __0,000

Mar.                __0,000

Apr.                __0,000

May                __0,000

   To complete the unit sales forecast, use the third, fourth, fifth and sixth digits of your student identification number to fill in the blanks.   If any of these digits contains a "0", use "3" instead.  

                  Example:   If student ID number is 00607357.   The sales forecast would be:

January            60,000

February          30,000

March              70,000

April                30,000

******************MY BANNER I.D IS 00307585*************** DONT USE THE SAMPLE BANNER I.D

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.

g.         The selling price per unit is $100.

REQUIRED:   Using Excel, in good form:

**********AGAIN MY BANNER I.D IS 00307585 ********

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

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

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

­

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were...
Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were 700, 680, 752, 712, and 780 respectively. Required: 1. The company’s policy for ending finished goods is 25 percent of next month's sales. Prepare a production budget for the first quarter. 2. The drone toy includes 2 LED lights, which cost $15 each. The company requires ending direct materials to be 20 percent of next month's materials requirement. Prepare a direct materials purchases budget...
Sutton Pointers Corporation expects to begin operations on January 1, 2015; it will operate as a...
Sutton Pointers Corporation expects to begin operations on January 1, 2015; it will operate as a specialty sales company that sells laser pointers over the Internet. Sutton expects sales in January 2015 to total $250,000 and to increase 15 percent per month in February and March. All sales are on account. Sutton expects to collect 66 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 10 percent in the second month...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb 20,000 units Mar 10,000 units Apr 20,000 units May 30,000 units Finished goods at the end of each month must be 10% of the next month’s budgeted sales. On Dec 31 of the last year, the finished goods totaled 2,000 units. The selling price is $1 per unit. 80% of the credit sales are collected in the month of sale, 15% in the month...
Thornton Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a...
Thornton Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a specialty sales company that sells laser pointers over the Internet. Thornton expects sales in January 2019 to total $360,000 and to increase 15 percent per month in February and March. All sales are on account. Thornton expects to collect 68 percent of accounts receivable in the month of sale, 21 percent in the month following the sale, and 11 percent in the second month...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011: January February March April Sales (units) 35,000 31,000 38,000 29,000 Each unit requires three hours of direct labor. Additional information: Karam sells each unit for $95. Company policy is to have 30 percent of next month's sales (in units) in ending finished goods inventory. Company policy is to have 40 percent of next month's production needs in ending raw...
Shown below are the expected unit sales for Jacks Company for the first quarter of 2018....
Shown below are the expected unit sales for Jacks Company for the first quarter of 2018. -----January February March Sales 1,500 2,000 3,000 In addition, expected sales in April and May are 4,000 and 5,000 units, respectively. They have a policy of maintaining a level of ending units sufficient to meet 90% of their sales demand for the following month. Each finished unit requires four pounds of direct materials. At the beginning of 2018, they had 6,000 pounds of direct...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 7,000 March $    15,000 February $    12,000 April $    18,000 Monthly purchases of raw materials accounts for 50 % of sales forecast for the next month. Of total raw material purchases , payments are 50% in cash in the same month and 50% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
Campbell Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a...
Campbell Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a specialty sales company that sells laser pointers over the Internet. Campbell expects sales in January 2019 to total $290,000 and to increase 15 percent per month in February and March. All sales are on account. Campbell expects to collect 69 percent of accounts receivable in the month of sale, 23 percent in the month following the sale, and 8 percent in the second month...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 6,000 March $    15,000 February $ 11,000 April $    17,000 Monthly purchases of raw materials accounts for 60 % of sales forecast for the next month. Of total raw material purchases , payments are 60% in cash in the same month and 40% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
1. Prepare a sales budget for January through May. The selling price per unit is $40.00....
1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year 40,000 January 90,000 February 80,000 March 70,000 April 40,000 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT