Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Campbell Soup Company (CPB) is a U.S. manufacturer and marketer of high-quality, branded food and beverage products. In 2018, CPB announced its vision to be

image text in transcribedimage text in transcribed

Campbell Soup Company (CPB) is a U.S. manufacturer and marketer of high-quality, branded food and beverage products. In 2018, CPB announced its vision to be a leading snacks and simple meals company, with a portfolio of best-in-class products and brands, and to pursue increased, multi-year cost savings initiatives. CPB provides selected financial data for fiscal year 2019: 377 From the Income Statement (In million dollars) FY 2018 FY 2019 Net sales $ 7,890 $ 8,700 Costs and expenses Cost of goods sold 4,734 5,394 Sales and marketing 902 Administrative expenses 654 R&D expenses 111 110 Other general expenses 457 422 Total cost and expenses 6,707 7,482 Operating income $ 1,184 $ 1.218 From the 2019 Balance Sheet (In million dollars) Beginning Ending Cash $ 319 $ 226 Accounts receivable, net 605 783 Raw materials inventory 244 Finished goods inventory 525 Other current assets 74 Plant assets, net of depreciation 2,454 3,233 Intangible assets, net of amortization 3,233 8,776 Other assets 139 224 Total assets $ 7,726 $14,161 855 550 589 86 For fiscal year 2020 master budget planning: 2020 expected sales is $9,500 (million) at an average unit sales price of $ 2.00 (e.g., per container of soup). 2020 expected beginning finished goods inventory is 475 million units. However, the desired ending finished goods inventory is set at 500 million units. All sales are on credit: 90% are collected in the same year, 9% the following year, and 1% is uncollectible. Each unit requires 20 ounces of ingredients. Expected beginning raw materials inventory is 4,870 million ounces of ingredients, but desired ending raw materials inventory is set at 5,000 million ounces. Raw materials cost an average of $0.05 per ounce. Materials purchases are made on account and 80% are paid in the same year and 20% in the following year. Materials purchased in 2019 totaled $8,448 (million). 2019 period expenses include $394 million of depreciation. Period expenses are paid in the following year. 1. (10 points) Use the master budget planning information above and the 2019 information from page 1 to compute the following amounts (in million dollars) for fiscal year 2020. Show your work and use cell-referencing for full credit. (Hint: Copy/paste page 1 data to this page). a. Units to be produced b. Cash receipts from credit sales c. Direct material ounces to be purchased d. Cash disbursements for raw materials purchases e. Cash disbursements for period expenses

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

College Accounting, Chapters 1-15

Authors: James A. Heintz, Robert W. Parry

21st Edition

1285639723, 9781285639727

More Books

Students also viewed these Accounting questions

Question

Show that y satisfies the requirements of a norma on ''.

Answered: 1 week ago

Question

Explain how to change negative self-talk into positive self-talk.

Answered: 1 week ago