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

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

Jan. 30,000

Feb. 60,000

Mar. 70,000

Apr. 70,000

May 80,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.

g. The selling price per unit is $100.

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).

Solutions

Expert Solution

ekkarill92 answered 8 months ago

Next > < Previous

Related Solutions

Rooney Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a...

Rooney 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. Rooney expects sales in January 2019 to total $230,000 and to increase 15 percent per month in February and March. All sales are on account. Rooney expects to collect 68 percent of accounts receivable in the month of sale, 22 percent in the month following the sale, and 10 percent in the second month...

Finch Pointers Corporation expects to begin operations on January 1, Year 1; it will operate as...

Finch Pointers Corporation expects to begin operations on January 1, Year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Finch expects sales in January Year 1 to total $370,000 and to increase 10 percent per month in February and March. All sales are on account. Finch expects to collect 65 percent of accounts receivable in the month of sale, 20 percent in the month following the sale, and 15 percent in the...

Stuart Pointers Corporation expects to begin operations on January 1, year 1; it will operate as...

Stuart Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Stuart expects sales in January year 1 to total $260,000 and to increase 10 percent per month in February and March. All sales are on account. Stuart expects to collect 68 percent of accounts receivable in the month of sale, 25 percent in the month following the sale, and 7 percent in the...

XYZ is a calendar-year corporation that began business on January 1, 2020. For the year, it...

XYZ is a calendar-year corporation that began business on January 1, 2020. For the year, it reported the following information in its current-year audited income statement. Notes with important tax information are provided below. Use Exhibit 16-6. XYZ corp. Book Income Income statement For current year Revenue from sales $ 40,000,000 Cost of Goods Sold (27,000,000 ) Gross profit $ 13,000,000 Other income: Income from investment in corporate stock 300,000 1 Interest income 20,000 2 Capital gains (losses) (4,000 )...

Peru Industries began operations on January 1, 2020.

Problem 8-6A Recording accounts receivable transactions and bad debt adjustments LO1, 2, 3Peru Industries began operations on January 1, 2020. During the next two years, the company completed a number of transactions involving credit sales, accounts receivable collections, and bad debts (assume a perpetual inventory system). These transactions are summarized as follows:2020Sold merchandise on credit for $2,310,000, terms n/30 (COGS = $1,276,000).Wrote off uncollectible accounts receivable in the amount of $35,200.Received cash of $1,378,000 in payment of outstanding accounts receivable.In...

Grouper Corporation was incorporated and began business on January 1, 2020. It has been successful and...

Grouper Corporation was incorporated and began business on January 1, 2020. It has been successful and now requires a bank loan for additional capital to finance an expansion. The bank has requested an audited income statement for the year 2020 using IFRS. The accountant for Grouper Corporation provides you with the following income statement, which Grouper plans to submit to the bank: Grouper Corporation Income Statement Sales revenue $ 846,000 Dividend revenue 32,000 Gain on recovery of earthquake loss (unusual)...

PROBLEMS 1. Rosotti Corporation began operations on January 1, 2005. Cost and sales information for 2005...

PROBLEMS 1. Rosotti Corporation began operations on January 1, 2005. Cost and sales information for 2005 is summarized below. Total costs of operations: Direct materials $60 per unit Direct labor $90 per unit Variable factory overhead $40 per unit Variable selling expenses $11 per unit Variable administrative expenses $10 per unit Sales price $400 per unit Fixed factory overhead costs $1,200,000 Fixed selling expenses $11,900,000 Fixed administrative expenses $12,100,000 Units produced 300,000 Units sold 250,000 Units in ending inventory 50,000...

Exercise 9-28 Cullumber Corporation began operations on January 1, 2020, with a beginning inventory of $39,852...

Exercise 9-28 Cullumber Corporation began operations on January 1, 2020, with a beginning inventory of $39,852 at cost and $50,000 at retail. The following information relates to 2020. Retail Net purchases ($110,100 at cost) $151,100 Net markups 10,100 Net markdowns 5,000 Sales revenue 129,000 Assume Cullumber decided to adopt the conventional retail method. Compute the ending inventory to be reported in the balance sheet. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0...

On January 1, 2020, Caliber Corporation issued 9% bonds dated January 1, 2020, with a face...

On January 1, 2020, Caliber Corporation issued 9% bonds dated January 1, 2020, with a face amount of $10 million. The bonds mature in 2029 (10 years). For bonds of similar risk and maturity, the market yield is 10%. Interest is paid annually on December 31. 1. What is the amount of the annual interest payment? 2. What is the price of the bond on the issue date? (state method used) 3. Was the bond sold at a discount or...

6. The stockholders' equity account balances of Kay Corporation for 2020 are given below: January 1...

6. The stockholders' equity account balances of Kay Corporation for 2020 are given below: January 1 December 31 Common stock ...................... 648,000 720,000 Paid-in capital – common stock .... 540,000 594,000 Treasury stock .................... 160,000 36,800 Paid-in capital – treasury stock .. 5,000 ? Retained earnings ................. 425,000 ? The common stock account at January 1 consisted of 54,000 shares that were outstanding at a $12 par value per share. The treasury stock account at January 1 consisted of 10,000...

Subjects