Befitting Fashion Ltd Cash Budget Assignment Help With Solution

Befitting Fashion Ltd Cash Budget Assignment Help

1.Befitting Fashion Ltd has provided the estimates below for the January – March quarter in 2015:
 

January February March
$ $          $
  Sales of inventory 70,000 80,000 90,000
  Purchases of        inventory 25,000 30,000 40,000
  Operating expenses 20,000 21,000 23,500

 
You are also given the following additional information:
 
•25% of sales are cash sales, the remaining 75% are credit sales and are collected as follows:
a)30% of credit sales are collected in the month of sale
b)70% of credit sales are collected in the following month after sale
 
•Sales in the month of December 2014 were $42,857.
 
•All purchase of inventory is made on credit and are paid for in the same month they are incurred.
 
•Operating expenses include depreciation expense each month of $3,000. All expenses are paid for in the same month they are incurred.
 
•Loan repayments of $10,000 per month are due to start in February.
 
•The firm expects to sell some old machinery for $5,000 in January. New machinery worth $70,000 will be purchased in March (depreciation expense will not change as a result).
 
•The cash balance on 30th December 2014 is $5,000.
 
REQUIRED:
 
a) Prepare a Schedule of expected receipts from Debtors (Account receivable) for Befitting Fashion Ltd for the three months January to March 2015. Show all workings.
 
b) Prepare a cash budget for Befitting Fashion Ltd for the three months January to March 2015. Show all workings.
 
c) Befitting Fashion Ltd is budgeting for a cash deficit at the end of one of the months included in their cash budget. Briefly explain how Befitting Ltd could prepare for this forecasted deficit.
 
2.A good friend of yours, who owns a fashion shop, is confused by her firm’s statement of financial performance and statements of financial position, and comes to you for help.
 
The statement of financial performance for the financial year ended at 30 June 2014, prepared by an accountant, shows a net profit of $110,000.
 
However, there is only a $65,000 increase from 2013 to 2014 in the balance of her firm’s Cash at Bank account in the statement of financial positions for those years.
 
She has checked with other accounting experts and they report no error or fraud.
 
Yet, your friend is still very puzzled why the $65,000 increase in her firm’s Cash at Bank account from 2013 to 2014 does not equal the net profit of $110,000 made in the financial year that ended 30 September 2014.
 
She is concerned about firm’s working capital and has provided you with the following ratios:
 

2012 2013 2014
Receivables turnover (days) 45 46 49
Inventory turnover (days) 58 61 62
Payables turnover (days) 46 45 43

 
REQUIRED:
 
a)Outline and discuss two reasons why a Net Profit amount can differ from the change in a firm’s Cash at Bank account from 2013 to 2014.
 
b)Calculate the operating cash cycle period (days) for the 3 years and comments on management of working capital over the past 3 years.
 
 

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to Case Id . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Case Approach

Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

Related Services


 
 
3.Ogleby Company estimates that 240,000 direct labor hours will be worked during 2010 in the Assembly Department. On this basis, the following budgeted manufacturing overhead data are computed.
 

Variable Overhead Costs Fixed Overhead Costs
Indirect labor $ 72,000 Supervision $ 75,000
Indirect materials 48,000 Depreciation 30,000
Repairs 36,000 Insurance 12,000
Utilities 26,400 Rent 9,000
Lubricants 9,600 Property taxes 6,000
$192,000 $132,000

 
It is estimated that direct labor hours worked each month will range from 18,000 to 24,000 hours. During January, 20,000 direct labor hours were worked and the following overhead costs were incurred.
 

Variable Overhead Costs Fixed Overhead Costs
Indirect labor $ 6,200 Supervision $ 6,250
Indirect materials 3,600 Depreciation 2,500
Repairs 2,400 Insurance 1,000
Utilities 1,700 Rent 850
Lubricants 830 Property taxes 500
$14,730 $11,100

 
Instructions:
 
(a) Prepare a monthly manufacturing overhead flexible budget for each increment of 2,000 direct labor hours over the relevant range for the year ending December 31, 2010.
 
(b) Prepare a manufacturing overhead budget report for January.
 
(c) Comment on management’s efficiency in controlling manufacturing overhead costs in January.
 
 
4.The Current Designs staff has prepared the annual manufacturing budget for the rotomolded line based on an estimated annual production of 4,000 kayaks during 2013. Each kayak will require 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks costs $1.50 per pound, and the finishing kits cost $170 each. Each kayak will use two kinds of labor—2 hours of type I labor from people who run the oven and trim the plastic, and 3 hours of work from type II workers who attach the hatches and seat and other hardware. The type I employees are paid $15 per hour, and the type II are paid $12 per hour.
Manufacturing overhead is budgeted at $396,000 for 2013, broken down as follows.
 

                 Variable costs
Indirect materials $  40,000
Manufacturing supplies

 

    53,800
Maintenance and utilities

 

    88,000
181,800

 

                       Fixed costs
Supervision

 

               90,000
Insurance

 

               14,400
Depreciation

 

 109,800

 
             214,200

 
During the first quarter, ended March 31, 2013, 1,050 units were actually produced with the following costs.
Polyethylene powder ………………………$ 87,000
Finishing kits …………………………………..178,840
Type I labor ………………………………………31,500
Type II labor ……………………………………..39,060
Indirect materials ……………………………10,500
Manufacturing supplies ……………….14,150
Maintenance and utilities …………26,000
Supervision ……………………………………20,000
Insurance ………………………………………….3,600
Depreciation …………………………………..27,450
Total …………………………………………..$438,100
 
Instructions:
 
(a) Prepare the annual manufacturing budget for 2013, assuming that 4,000 kayaks will be produced.
 
(b) Prepare the flexible budget for manufacturing for the quarter ended March 31, 2013. Assume activity levels of 900, 1,000, and 1,050 units.
 
(c) Assuming the rotomolded line is treated as a profit center, prepare a flexible budget report for manufacturing for the quarter ended March 31, 2013, when 1,050 units were produced.
 
 

Product Code :Acc-sol-19

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)
 
You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.

Summary