Master Budget, Cash Budget and Budgeted Income Statement

After two years of study at ASM, you finally graduate and start a job as a junior accountant at Glow Inc.

Your manager is responsible for the nationwide distribution of creator$-$design product lines. Due to the

prevalence of social media, the company has grown rapidly, and the rapid growth in its lighting products

forces the management team to improve their production efficiency.

You have just been responsible for planning and budgeting the entire lighting set division. Today is your

first day, and you have just been given an assignment to prepare a master budget for the manager, who

needs to present the budget and discuss the financial objectives with the shareholders tomorrow. During

your job interview, you clearly stated that you gained managerial accounting knowledge and hands$-$on

experience while studying at ASM.

Your first assignment is to prepare a master budget for the next fiscal year, starting January $1,2024,$ and

your co$-$worker has left a pile of files on your desk, including the sale records, product information,

manufacture schedule and supplier pricing list. Now, you realize that you should have paid more attention

in class. Now, you don$$t know where to start. Fortunately, you remember keeping a copy spreadsheet of

the master budget template on your laptop from the accounting course.

Note:

Sales and Marketing

Glow products are sold to retailers for $$50$ each, and the sales have been in demand due to Covid$-19.$

However, the marketing department has been conservative toward the end of the year due to market

saturation. The marketing department has just sent you their forecasted quarter sales and marketing

budget.

Quarter $2023$ Q$12023$ Q$22023$ Q$32023$ Q$42024$ Q$12024$ Q$2$

Sales in Unit $25,00026,00025,00025,00027,00026,000$

Advertising $$25,000$ $$25,000$ $$25,000$ $$25,000$ $$25,000$ $$25,000$

Production and Inventory

Ending finished goods inventories should equal $20\%$ of the next quarter's unit sales. Glow currently

does its assembly production in$-$house. Each unit consists of $3$ LED panels, and the cost of each is $$5.$

Each unit needs one labour hour from assembly to finish package. The hourly pay rate for the

assembling workers is $$20$ per hour.

The production manager also required the desired direct material ending inventory to $20\%$ of the next

quarter's production.

Product and Period Costs

Below is a display of the Glow division quarterly manufacture overhead and selling and

administrative expenses:

Manufacture Overhead Variable:

Indirect labour $$3$ per labour hour

Indirect Materials $$2$ per labour hour

Fixed:

Wages and Salaries $$5,000$

Utilities $$3,000$

Maintenance $$3,000$

Insurance $$5,000$

Depreciation $$5,000$

Rent $$12,000$

Selling and Administrative

Variable:

Sales Commissions $$2$ per unit

Fixed $($quarterly$)$:

Wages and Salaries $$100,000$

Utilities $$15,000$

Insurance $$5,000$

Depreciation $$5,000$

Miscellaneous $$8,000$

Cash, Accounts Receivable and Accounts Payable

The company desires a minimum ending cash balance each quarter of $$250,000.$ All sales to the

distributors are made on credit terms with no discount $($for now$)$ and payable within $45$ days. The Glow

has determined that only $50\%$ of sales are collected by the end of the quarter in which the sale

occurred. The rest $50\%$ is collected in the quarter following the sale.

Purchases are paid for in the following manner: $50\%$ in the quarter of the purchase and the remaining

$50\%$ paid in the quarter following the purchase.

Additional Information

Labour, manufacturing overhead, and Selling and Administrative expenses are all paid

during the month, in cash, except depreciation $($of course$).$ Glow will make

a warehouse purchase during the second quarter of $2022$ for $$250,000$ cash. Glow's

balance sheet at the end of the fourth quarter last year is shown below:

Assets

Cash $$250,000$

Accounts receivable $$200,000($uncollected from Q$4$ last year$)$

Liabilities

Accounts payable $$180,000($unpaid from Q$4$ last year$)$

An agreement with Bank of the West allows Glow to borrow up to a total loan amount of

$$500,000($maximum amount$).$ The interest rate on these loans is $12\%$ annually

Required:

Prepare a master budget for $2024.$ Include the following budget schedules and financial statements as if

there is no income tax $1)$ Master Budget $2)$ Cash Budget. Show the cash budget by quarter. $3)$ Budgeted

Income statement by quarter and annual