Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me find(1) Overhead budget and(2) selling and administrative Budget using Excel format providing below.Note: you can add more rows it neededPlease provide excel

please help me find(1) Overhead budget and(2) selling and administrative Budget using Excel format providing below.Note: you can add more rows it neededPlease provide excel formula

image text in transcribed
Budget Excel Project Bloomeld Co. Bloomeld is an ice cream company, who makes homestyle ice creams using fresh and all- natural ingredients and sells to retail stores. In preparing the budget for the coming year, 2024, the).r forceasted the following expected sales and gathered the costs data from managers in various areas of the company. Sales ' F oreeasted to sell 25,000 units in the 151 Quarter of 2024, and an additional 2,000 units each quarter. ' The 2,000 additional units per quarter are expected to continue through the end of 2nd quarter of 2025. ' The 2023 4'h quarter sales were 24,000 units. ' Selling price for one unit ofice cream is $15. ' Bloomeld maintains [5% of the next quarter's unit sales in ending inventory. - All sales to retail stores are on account, with collections of 75% made in the quarter of sales and 25% collected in the quarter after sale. ' Accounts receivable on December 31, 2023 is $2000. Direct Materials '- Direct materials cost $3 per pound. 1.5 pounds of direct materials are required to produce each unit. ' Bloomeld maintains 6% of the materials needed for the next quarter in its ending material inventory. ' Raw Materials on December 31, 2023 were 2,250 pounds. ' Payment for materials are made 50% in the quarter of purchase. and 50% in the quarter after purchase. ' Accounts Payable balance on December 3], 2023 was $56,250

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

7th Edition

0137858515, 9780137858514

Students also viewed these Accounting questions