Finished goods inventory, Finished goods inventory is

Finished goods inventory

Assignment Help Financial Accounting

Reference no: EM13916727

Comprehensive Master Budget. Creative Shirts, Inc., produces T-shirts. The company's fiscal year ends on December 31. Information to be used for the operating budget this coming year follows.

Sales and Production-Related Budget Information

Average sales price for each T-shirt is estimated to be $15. Unit sales for this coming year, ending December 31, are expected to be as follows:

First quarter	20,000
Second quarter	24,000
Third quarter	28,000
Fourth quarter	18,000

Finished goods inventory is maintained at a level equal to 10 percent of the next quarter's sales. Finished goods inventory at the end of the fourth quarter budget period is estimated to be 2,000 units.

Each unit of product requires 3 yards of direct materials, at a cost of $2 per yard. Management prefers to maintain ending raw materials inventory equal to 20 percent of next quarter's materials needed in production. Raw materials inventory at the end of the fourth quarter budget period is estimated to be 12,200 yards.

Each unit of product requires 0.1 direct labor hours at a cost of $14 per hour.

Variable manufacturing overhead costs are

Indirect materials	$0.70 per unit
Indirect labor	$0.90 per unit
Other	$0.50 per unit

Fixed manufacturing overhead costs per quarter are

Salaries	$18,000
Other	$20,000
Depreciation	$11,950

Selling and Administrative Budget Information

Management estimates all selling and administrative costs are fixed.

Quarterly selling and administrative cost estimates for the coming year are

Salaries	$15,000
Rent	mce_markernbsp; 5,000
Advertising	mce_markernbsp; 4,000
Depreciation	mce_markernbsp; 9,000
Other	$10,000

Capital Expenditures and Cash Budget Information

The company plans to pay cash for selling and administrative equipment totaling $15,000 and production equipment totaling $9,000. Both will be purchased at the end of the fourth quarter and will not affect depreciation expense for the coming year.

All sales are made on credit. The company expects to collect 70 percent of sales in the quarter of sale and 30 percent the quarter following the sale. Accounts receivable at the end of last year totaled $80,000, all of which will be collected during the first quarter of this coming year.

All direct materials purchases are on credit. The company expects to pay 80 percent of purchases in the quarter of purchase and 20 percent the following quarter. Accounts payable at the end of last year totaled $25,000, all of which will be paid during the first quarter of this coming year.

The cash balance at the beginning of this coming year is expected to be $30,000.

Budgeted Balance Sheet Information

Assume 30 percent of fourth quarter budgeted sales will be collected in full the following year (this represents accounts receivable at the end of the fourth quarter).

Expected account balances at the end of the fourth quarter are

Property, plant, and equipment (net)	$100,000
Common stock	$250,000

Actual retained earnings at the end of last year totaled $42,720, and no cash dividends will be paid during the current budget period ending December 31.

Required:

Prepare the quarterly sales and production-related budgets using the figure formats referenced here:

Sales budget .

Production budget .

Direct materials purchases budget .

Direct labor budget.

Manufacturing overhead budget.

Prepare a quarterly selling and administrative budget using the format shown in Figure 6.8 "Selling and Administrative Budget for Jerry's Ice Cream".

Prepare a quarterly budgeted income statement using the format shown in Figure 6.9 "Budgeted Income Statement for Jerry's Ice Cream".

Prepare a quarterly capital expenditures budget using the format shown in Figure 6.10 "Capital Expenditures Budget for Jerry's Ice Cream".

Prepare a quarterly cash budget using the format shown in Figure 6.11 "Cash Budget for Jerry's Ice Cream".

Prepare a budgeted balance sheet at December 31 using the format shown in Figure 6.12 "Budgeted Balance Sheet for Jerry's Ice Cream".

Why does management at Creative Shirts, Inc., prepare a master budget? Explain

Reference no: EM13916727

Questions Cloud

Income student loans savings and nontaxable scholarship : Roy and Brandi are engaged and plan to get married. During 2015, Roy is a full-time student and earns $9,000 from a part-time job. With this income, student loans, savings, and nontaxable scholarships, he is self-supporting. For the year, Brandi is e..

Concepts of effect size and statistical significance : What does p = .05 mean? What are some misconceptions about the meaning of p =.05? Why are they wrong? Should all research adhere to the p = .05 standard for significance? Why or why not? Compare and contrast the concepts of effect size and statist..

Ability to monitor natural phenomena and disasters : In this assignment, you will research resources available on the Internet for monitoring natural phenomena including earthquakes, volcanoes, tsunamis, global climate, and weather.

Building an online community on facebook : Building an Online Community on Facebook. Chances are you already have a Facebook profile and communicate with friends and family. You may be a fan of a celebrity or a business.

Finished goods inventory : Finished goods inventory is maintained at a level equal to 10 percent of the next quarter's sales. Finished goods inventory at the end of the fourth quarter budget period is estimated to be 2,000 units.

What differences observed in implementation of concepts : Because this company is based in over 23 countries what are the differences observed in the implementation of these concepts from one country to another?

Data showing the results of six subjects on a memory test : What is the probability that you will make a Type I error given that the null hypothesis is true

Find the probability : In 2003, it was reported that 40% of all car accidents in Connecticut were alcohol related. Find the probability that fewer than 36 were alcohol related

Advantage and disadvantage using u s court of federal claims : List an advantage and a disadvantage using the U.S. Court of Federal Claims as the trial court for Federal Tax litigation.

User Account

All Pages