Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pleqse do steps 3 , 4 , 5 , 6 , 7 , and 8 . Please format your response like an excel spreadsheet and

image text in transcribed
Pleqse do steps 3,4,5,6,7, and 8.Please format your response like an excel spreadsheet and display the formulas required for each row on the far right side. For reference, I attached screenshots of my progress thus far.
The Sweet Crunch Company produces and sells organic Sweet Potato Chips. The one-pound family size bag of chips has two direct materials Organic Sweet Potatoes and packaging. The production process includes slicing the potatoes, lightly frying them, and lightly seasoning them with salt. Indirect materials include small amount of oil used to fry the chips and salt. Sweet Crunch is preparing budgets for the third quarter ending September 30,2024. For each requirement below prepare budgets by month for July, August, and September, and a total budget for the quarter.
1. The previous years sales (2023) for the corresponding period were:
July 50,000 bags
August 60,000 bags
September 75,000 bags
October 65,000 bags
November 55,000 bags
The company expects the above volume of sales to increase by 9% for the period July 2024 November 2024. The budgeted selling price for 2024 is $9.00 per bag of chips. The company expects 40% of its sales to be cash (COD) sales. The remaining 60% of sales will be made on credit. Prepare a Sales Budget for Sweet Crunch Company.
2. The company desires to have finished goods inventory on hand at the end of each month equal to 11 percent of the following month's budgeted unit sales. On June 30,2024, Sweet Crunch expects to have 5,995 bags of chips on hand. Use the @ROUNDUP function to round up to the nearest whole number of units in desired ending inventory. Prepare a Production budget.
3. The final product (bags of chips) requires two direct materials: sweet potatoes and packaging. 4 pounds of raw potatoes are required for each one-pound bag of potato chips. Management desires to have materials on hand (i.e., pounds of potatoes) at the end of each month equal to 20 percent of the following month's production needs. The beginning materials inventory, July 2024, is expected to be 44,560 pounds. Potatoes cost $1.20 per pound.
Packaging material is purchased by the roll and 100 bags of chips are produced from each roll. The packaging is made from biodegradable, organic plant fiber that extends the shelf life of the potato chips while preserving its freshness. Management desires to have packaging on hand at the end of each month equal to 15 percent of the following month's production needs. The beginning inventory of packaging (i.e., rolls of packaging material) in July 2024 is expected to be 84 rolls. Packaging is expected to cost $18 per roll.
Note, budgeted production in October is required in order to complete the direct materials budget for September. Also, use the @ROUNDUP function to round up to the nearest whole number of pounds of potatoes and number of rolls of packaging both for desired ending inventory and material to purchase. Further, because two direct materials are required for production potatoes and rolls of packaging - you will need a separate schedule for each direct material. Prepare a Direct Materials budget.
4. Each bag of chips requires 0.02 hours of direct labor. Each hour of direct labor costs the company $22. Prepare a Direct Labor budget.
5. Sweet Crunch Company budgets indirect materials (e.g., salt, oil) at $0.20 per bag. Sweet Crunch treats indirect labor and utilities as mixed costs. The variable components are $0.40 per bag for indirect labor and $0.30 per bag for utilities. The following fixed costs per month are budgeted for indirect labor, $30,000, utilities, $5,000, and other, $15,000. Prepare a Manufacturing Overhead budget.
6. Variable selling and administrative expenses are $0.70 per bag of chips sold. Fixed selling and administrative expenses are $25,000 per month. These costs are not itemized, i.e., the budget has only two line items variable operating expenses and fixed operating expenses. Prepare an Operating Expenses budget.
7. Prepare a Budgeted Manufacturing Cost per unit budget. Refer to exhibit 9-11 for guidance. To calculate FMOH/unit calculate total FMOH for the year and divide this by budgeted production for the year. The total production volume for the year is budgeted at 800,000 bags.
8. Prepare a Budgeted Income Statement for the quarter for Sweet Crunch Company. Assume interest expense of $0, and income tax expense of 25% of income before taxes. Sweet Crunch Companys goal for the quarter is to make its net income greater than 10% of its sales revenue. To determine whether the company achieves the goal, use @IF function. In the IF function, you need to label Achieved if it achieves the goal (if the condition is met) or Not Achieved if it does not achieve (if the condition is not met). Use the CELL right next to Net Income cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue*10%) is met or not.
image text in transcribed

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

Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

27th edition

978-1337272094, 1337272094, 978-1337514071, 1337514071, 978-1337899451

More Books

Students also viewed these Accounting questions

Question

method cannot be overridden

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago