Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Semester Case - Cowboy Ice Cream, Inc. Assuming the expansion of CIC takes place, W.L. is trying to prepare a sales budget for the year

image text in transcribed
image text in transcribed
image text in transcribed
Semester Case - Cowboy Ice Cream, Inc. Assuming the expansion of CIC takes place, W.L. is trying to prepare a sales budget for the year following the expansion. Currently he's working on data for the wholesale division. Using the information compiled above, complete the following. Assume that selling and administrative expenses are 15% of sales revenue. During the first six months of the year, the price charged averaged $7.75 per unit. Round all computations to the nearest whole dollar. First Quarter Second Quarter Total Sales Revenue Cost of Goods Sold Gross Profit Selling and Admin. Expenses Net Income Frank, W.T.'s fellow shareholder, told W.1. he expects sales next year after the proposed expansion) to be 20 percent greater than the current year. Required Prepare a pro forma income statement including quarterly budgets for the first six months of next year, using Frank's estimate. First Quarter Second Quarter Total Sales Revenue Cost of Goods Sold Gross Profit Selling and Admin. Expenses Net Income Semester Case - Cowboy Ice Cream, Inc. As CIC considers expanding by adding a fixed location, W.1. realizes that budgeting properly for inventory is more important than ever. As you know from prior work, the wholesale division of CIC began January with 1.250 units of inventory at a cost of $4.00 per unit. During the first six months of the current year, CIC recorded the following transactions related to inventory for the wholesale division: Sales (units) Month Beginning inventory January February March April May June Totals 1.500 1,600 1,750 3,100 4,500 4.800 17.250 Purchases Units Price Ea. 1.250 $4.00 1.000 $4.50 1,200 $4.60 1,700 $4.40 2.900 $4.75 5,000 $4.85 4,500 $4.90 17.550 Total $5.000 $4,500 $5.520 $7.480 $13.775 $24.250 $22,050 $82,575 Relative to June, the company projects a 3 percent increase in cost of goods sold during July The desired ending inventory balance for July is $2.500. CIC pays cash to settle 60 percent of its purchases on account during the month of purchase and pays the remaining 40 percent in the month following the purchase. The accounts payable balance as of June 30 was $8.820. What is ending Inventory. in dollars and units, at June 308 CIC applies the FIFO cost flow assumption. Semester Case - Cowboy Ice Cream, Inc. (cont.) b. What is costs of goods sold in total and for each of the six months ending June 302 Month Cost of Goods Sold January February March April May June Total c. Determine the amount of purchases budgeted for July. d. Determine the amount of cash payments budgeted for inventory purchases in July

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The Productivity Audit

Authors: Mark Spelman, Paul Spence

1st Edition

1907766073, 978-1907766077

More Books

Students also viewed these Accounting questions

Question

1. Identify three communication approaches to identity.

Answered: 1 week ago

Question

d. Who are important leaders and heroes of the group?

Answered: 1 week ago

Question

3. Describe phases of minority identity development.

Answered: 1 week ago