Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

The Bear Corporation will begin business operations on January 1, 2021. Below is the anticipated SALES BUDGET (in units): 43 Jan. Feb. Mar. Apr. May

image text in transcribed
The Bear Corporation will begin business operations on January 1, 2021. Below is the anticipated SALES BUDGET (in units): 43 Jan. Feb. Mar. Apr. May 0,000 2 30,000 50,000 10,000 30,000 1. Tocomplete the unitates threats the third, fourthi, fiftrand sixth disits of your menu in the blanks. If any of these digits contains (", use instead. Example: If student ID number is 00607357 The sales ferocas would be: January 60,000 February March 20.000 April 30,000 ADDITIONAL INFORMATION 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. a. c: e. Labor cost is $10 per unit produced. d. Ending raw material inventory should be equal to 20% of next month's material requirement. 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. 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson

6th edition

978-0077328894, 71313974, 9780077395810, 77328892, 9780071313971, 77395816, 978-0077400163

Students also viewed these Accounting questions

Question

What do you like to do for fun/to relax?

Answered: 1 week ago