Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started